Multi-Table Queries (Where to Start?)

[dccjr]

I have about 11 tables in a database. One of these is IDInfo. All of the other tables have a relationship etablished with IDInfo based on the WPSNo field in each. I am trying to query these tables for the entire row associated with the selected WPSNo from each table. I have read multiple posts on cross tab queries, but can't make heads or tails of how to apply them to my situation.

I need to set this up in VBA as the WPSNo selection is made by the user from a combo box.

Finally, I have to display each of each value in textboxes on a multi-tabbed form multi-tabbed. Can someone point me in the right direction?

[June7]

Don't know that crosstab is relevant.

What is the relationship type - 1 to 1 or 1 to many or many to many?

Do you want the form to allow data entry/edit? Set up a form/subform arrangement. Put subforms on pages of tab control. Or build a navigation form (I don't like the navigation form).