This may be a bit longwinded and I am hoping I can explain what I am trying to do well enough to get the help I need. Here is what I am attempting to accomplish:
I have one mass layout in table mode, this is imported from Excel. I am trying to link one field of the table to another table, again imported from Excel so that when I select that record, I can open the second imported file. I am hoping that in the end, I can search for a serial number in the second imported file from the main table. I know this sounds rudimentary but I have been attempting to work with relationships and containers all week with no luck. I can insert the second file into a container on the main table however this is only useful in that I can open that file, not search for a given serial number.
I have thought about seperating the main table into individual tables and making a relationship into another table, would that help in the effort of what I am trying to accomplish?
Once I get this worked out, I would like to create a nice form to input new data, and also search previous data that would all be linked to the original main table.
Thanks in advance for any help.