My relationships are almost done. I have a form that update a field of stock material. N to 1 relation. Very fine... but i want that the stock field update the several materials of my stock. Like cars - you have a stock field that determines the number of cars made but you need that the fields of the pieces of the car be updated. Help is wanted. If you want any more details please contacte me. Thanks Pedro

Create A Table With The Field Content In It. Then Link That to your main table.

Once this is done make the make the fields look like a label on your maintenance screens. If linked correct then when changing the fields the headings (field headings) will appear to change as well (due to them being linked).


Hope this what you mean if not then e-mail me wih your db or criteria at .


Matthew.Saunders@BSI-Global.com


And I will create a little example db of what you want.