AnsweredAssumed Answered

Newbie question

Question asked by GaryHarter on Oct 15, 2010
Latest reply on Oct 15, 2010 by philmodjunk


Newbie question


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.