Putting the related table inside the same file, linking it in a relationship and then placing a portal to the related table on your layout in place of the individual fields is the simplest way to go here.
It's hard to tell from your post exactly where this process breaks down for you. Can you spell out the steps you are taking and when/where it fails to work for you?
When I try to populate my new related table I will call it ABGdata with data from an excel spreadsheet the table ABGdata is greyed out.
My only option is to create a new table based on the excel file.
My original or main table is listed first and the ABGdata table is not avail.
When i did this using ABGdata as it's only table a separate database I did not have this problem
Go to the layout based on the new table, then select Import Records from the File menu. Import Records (when not run from a script) always sets up to import into the current layout's table so to select a different table, you have to select a layout based on it. That's one reason to keep at least one layout for every table in your file even if it does not need to be directly used by people working with your databse. (And it can be omitted from the layout drop down when your file is in browse mode to hide it from your users.)
Thanx for your help.
I am going to try it out