I have a new inventory database, it organized sales by model number, so right now i have 3 different model numbers (all linked as a relationship) When I view each record (model #) I see all the transactions for that model number)

I am trying to create an expense layout that shows all transactions for all model #'s, but when I created the new table it only displays transactions per model number, and I need all model numbers at the same time.

any help greatly appreciated!!! Urgent!!

Thanks

Matt

Cartesian connection Shows all Records [X] from transactions to Model #

It would help to see file though.

eg; Model_ID [X] Model_ID (transactions table)

would show all Model_ID's

I'm a little confused about a couple things. What actual tables do you have?

I am trying to create an expense layout that shows all transactions for all model #'s

If you have tables for models and a table of transactions then a layout based on transactions will show you all records in the transactions table. You can make the layout a sub-summary report to group them by model number.

but when I created the new table

What do you mean by this? What new table are you creating?