Record Relations

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)

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


"VainDM" wrote:

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)

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




"VainDM" wrote in message
...
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)