Hi all,
Newbie here in as much as this is the first time I havejoined a forum to get help.
I am OK 'ish with building basic DB's but I have come stuckwith one that I hope you help me with.
I am building a Stock Control DB for products. Each productconsists of various components, which I have managed to sort out (productdetails in main form (frmProducts) and components in the subform(sfmComponents) however, some components are used on more than one product andthis I haven't been able to sort out. How can I allocate a component tomultiple products? I do not have any experience with VBA (apart from how toaccess it from 'Properties', so if this the only solution could someone pleaseprovide me with the code.
Many thanks in advance.