Record Relations

[VainDM]

hi is there a way of say having a list of records, and having a text box on
the list noting how many records are related to that one;

eg a list of products
product name; product number; qty

but then has a text box noting the number of materials related to the
product (if each material has its own record)

 

[Mr. B]

What you want to do can be done. However, you would need to do this in a
form, not in a table. You would use the DCount function to get the counts
from the associated tables for any current product.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Steve]

It sounds like you need tables that look like:
TblProduct
ProductID
ProductName
ProductNumber
Qty

TblMaterial
MaterialID
Material

TblProductMaterial
ProductMaterialID
ProductID
MaterialID

For each product, TblProductMaterial would record each material related to
the product. A totals query based on TblProductMaterial with an appropriate
criteria for ProductID could then give you the total material items for any
selected product.

Steve
(e-mail address removed)