problem - tables

[eran3185]

hey

i have 2 tables :
big (primery) , small (sub).
i want that the sub-form will get automaticcly the numberof the primery
i.e : when the deal number = 2 , all the "deal number" fields in the sub-form (small) get "deal number=2" automaticcly .

[eran3185]

:doh:

[mattj]

You should use a sub-form for this with the "Deal Number" attribute used for the Master/Child fields.

BTW, I suggest that remove any spaces or special characters from the names of any database objects. (attributes/fields, controls, tables, queries, etc...)