MS Access table relations help
MS Access table relations help
(OP)
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
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





RE: MS Access table relations help
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'.
RE: MS Access table relations help
These can prevent you adding a record to one table if it does not find the field value in the other table.
RE: MS Access table relations help
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.