Search results

After taking a look at the sample many to many you posted I am now even more confused. If I create a fk with Engineerid in ECR then how can I also have a linked table for models and adc? I have tried to create this but I can not get any referential integrity with it. Please take a look at the...

I have had problems with the relationships, that was the only way I could get what I needed without too much headache. A description of the database: An engineer writes an ECR to modify one or more models. This being said; An ECR can have one engineer, one or more ADC (add/delete/change) that...

Thanks It seems like it is always the easy things that slip by me. Thank you for the great help.

In the attached db I wanted to create several relationships between tables. After doing this, it created a table_1 table to show the links. Is this normal?

Subform linked to Main form (Help) Hello, I recently was introduced to access 2000 and have created an Engineer Change Request tracking database. I have one problem though, I cannot seem to have my subforms display only the relavant information that should be passed from the main form. Both...