Need help assembling this Queries/Form

P

postman

Need help assembling this Queries/Form.

Tables are:
Tbl_Customer - For recording customer details (name, address etc.) &
generating a customer number (autonumber).
Tbl_SBuy Contracts dB - Records items sold by the customer (many for one
contract) many contracts over time for the one customer.
Tbl_TAG Contracts - Records contract number for each purchase from the
customer (customer number), there are many contracts over time from the one
customer.
ALSO Tbl_Contracts_JNCTN - for the Many to Many relationship between
Tbl_SBuy Contracts dB & Tbl_TAG Sbuy Contracts; due to the many contracts &
many Items for the one customer.

Relationships are:
Tbl_Customer:CustomerID (PK) 1 to Many with Tbl_TAG Contracts:CustNoID (FK)
Tbl_SBuy Contracts dB:SBuy_ContractsID (PK) 1 to Many with
Tbl_Contracts_JNCTN:SBuy_ContractsID (FK)
Tbl_TAG Contracts:ContractNoID (PK) 1 to Many with
Tbl_Contracts_JNCTN:ContractNoID (FK)

I think the relationship part works!

When I try to make a form using "Form Wizard" or using Queries, it won't
link the forms to show all the conections & records.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding matches in an array 3
Sub-Form - Don't show active record 5
Append new records but don't create duplicates 4
what makes this query not updatable 7
Query to find multiple records for Customer_ID 1
Table Normalization Help 3
Is Relational Hierarchy Possible with Excel 4
Stumped on one query for a form Please help 1

Top