Inventory Questions

[KLee]

Hello. I am a relative newbie "STILL". I am creating a database from the ground up. I have many tables already defined. I have one main table from whence all my data comes from. I have broken down into different sections smaller tables relating to the main one. All of this is linked (or trying to link) by ID #(serial #). I chose to import the main data and each smaller sections data from excel (seperately) (easier to break down that way, I thought). How can I use the get the ID#'s to coincide. I thought lookups, but being so new, I'm not sure I'm doing it right. All tables are related via ID#, doing lookups based on ID prove no results brought over. What am I doing wrong??

[LiveOak]

I'm afraid that's way to little information to answer your question. The devil is in the details and we'll need a few more.

The general approach is to import data and use whatever native information is available to make temporary links between the tables and use these relationship with lookups to populate the final keys.

-bd

[KLee]

What other details would you need, I thought I gave all relevant info?

[Cin]

I'm assuming that each table has an ID field with a serial number in order to make it unique. You should create another ID in each table referencing the child tables with the same name as the ID in the child table. You can then create relationships based on these identical fields.

Example:

Table A (parent)

ID~A

ID~B

Field1

Field2

etc...

Table B (child)

ID~B

Field1

Field2

etc..

The relationship is Table A::ID~B and Table B::ID~B

Cin

[KLee]

Thanks for your reply.

I had my relationships wrong. Figured it out.

I can now do lookups, thanks to your advice.