Displaying two different tables as one?

[Neimad]

I have two tables. Now other than the relationship they have the details are pretty much the same. The only reason they are in two tables is so i could could have a sub-record kinda thing.

I have two forms one for sub and one for main. But there may be times I need all the records on screen for filtering (say location) where the parent-child relationship is not important. Is it possible to have a way that all the records can be access and changed without needing two forms (or one form with repeating input boxs). I was thinking query? This is all to make it easier to find a record without wondering if its in this table or that table?

 

[Bob Miller]

I have two tables. Now other than the relationship they have the details are pretty much the same. The only reason they are in two tables is so i could could have a sub-record kinda thing.

I have two forms one for sub and one for main. But there may be times I need all the records on screen for filtering (say location) where the parent-child relationship is not important. Is it possible to have a way that all the records can be access and changed without needing two forms (or one form with repeating input boxs). I was thinking query? This is all to make it easier to find a record without wondering if its in this table or that table?

What is a "sub-record kinda thing"? Do you mean that you have duplicate data in the two tables or unique data in each. Either way, you are finding out the difficulties in doing whichever it is.
How much are the details "pretty much the same?
Tell us the fields in each table and maybe we can help.

 

[Neimad]

Ok, The table stores addresses, towns, names, etc. Both tables contain the same data. The ONLY difference is that some of these companys belong to other companys in the first table. So I have a secound table that contains all these 'sub companys' and a ID that tells it which company it belongs too.

 

[Bob Miller]

Ok, The table stores addresses, towns, names, etc. Both tables contain the same data. The ONLY difference is that some of these companys belong to other companys in the first table. So I have a secound table that contains all these 'sub companys' and a ID that tells it which company it belongs too.

You would be better off to have just one table with an additional field of OwnerCompany. You could use the company names from this table to fill in that new field in a form combobox.