Are you trying to create an actual table such as that defined in Manage | Database | tables or just display this data in a table format on a layout?
Is this something you want the user to to do after selecting different filter values or a one time design change of your database?
What is the "big picture" result that you want here?
The big picture is that I have two lists where the user can enter data. One list has fields A,B, C, D. The second list has only A, B. I then want to display info from each list in one list for the user. For example, show me all the entries where A=some value.
I think I figured it out. I can use a match field to identify the second list (A, B) , and a second match field to define the category for display. Does that make sense?
I have absolutely no one to bounce ideas off of, or best practices, so any help is greatly appreciated!
Well "bouncing ideas off people" is one of the functions of a forum like this.
I really don't know if what you want to do is the right approach or not as it depends on what actual data you have in each table and what you want to do with this "list" once you have pulled it up on a screen on your computer.
What does one record in the first table represent? What does one record in the second table represent?
You might actually have data in two tables where you really only need one. Then again, you might really need two. I can't tell from the info provided thus far.