MS Access table relations help

[NCCGRAD]

Hey,

I was assigned to biuld an ECO database right. Im not all that good with Access, but i think i did alright. I have one table that retreives data from another table through the use of a list box. The information is coming from a Master P/N table. The table that is retreiving the info is an ECO record table. Even though it is taking from the Masters data, i can still plug in P/N's that are not on the master table. How can i prevent this.

And also on a side note. Im utilizing a switchbaord for navigation for the rest of the company. I have a couple queries that have input parameters. I want to try and get it where i can put in a range of ECO #'s (thats what the parameter is), not just a single ECO#. If there is a way for that would be much appreciated.

Thanks in advance,
~~Joe

 

[cowski]

i can still plug in P/N's that are not on the master table

Have you set up a form for the data input? You say it is a list box, but if you can type numbers into it, it sounds more like a combo box. The control should have a 'limit to list' property, make sure it is set to 'yes'.

 

[FrancisL]

Have you set up the relations between fields in the tables?
These can prevent you adding a record to one table if it does not find the field value in the other table.

 

[NCCGRAD]

Hey Thanks guys,

I was pokling around access to try and find something, (very stuborn german, haha). I hate giving up. But yea, when i was switching things around in design mode, i happen to stumble upon the "Limit to List" option.

And yes, i did have te relationships between the two fields.

Appreciate the feedback though. Thanks again guys.