Newbi Help

[rama1712]

I have been asked to create a DB in access of computer inventory.

I have several tables setup
Station Name
Room Location
Staff Name
Department

I then have another table setup that has 4 Lookup fields linked to above. Table called inventory

What I want to happen is when you entery Data in to the table Inventory if it is not present in the 4 above tables it is automacticly added.

When I sent relationships i come up with differnet messages

I have tried 1 to many 1 to 1 .

Can someone please send me an example DB or screenshots.
Of what I need to do.

Thanks

I can send the DB to you if it would help.

Thanks
Stuart
stuart@rama1712.com

 

[jrbarnett]

Stuart,

The relationships that you need to set depend on the exact logic you want to set. The way I was taught at university was to use the word "Each". For example:

Each [table 1] Has a [table 2]

results a 1:M connection between table 1 and table 2.

Each [table 1] is a [table 2]

results in a 1:1 relationship between table 1 and table 2.

If the resulting sentence doesn't make grammatical sense, then it is a good indication that the tables are named incorrectly, unless you are following a naming convention with the table objects.

John