Hi
In a hyperthetical situation if Fred and Jim are both a customer and a supplier.
How would I structure the relationships/joints so that I only keep 1 table whether they be suppliers or customers, but on a form I want to say I have bought items off Fred and sold them to Jim.
When using the form wizzard, once I have selected the 'Name' field from the cust/suppliers table (for the bought from) that field dissapears from the dropdown box in the wizzard, so how do I then select it again for the (sold to).
Hope this makes sense....
The lower tech the better solution for me as I am still finding my feet with Access, but loving the experience.
Thanks
In a hyperthetical situation if Fred and Jim are both a customer and a supplier.
How would I structure the relationships/joints so that I only keep 1 table whether they be suppliers or customers, but on a form I want to say I have bought items off Fred and sold them to Jim.
When using the form wizzard, once I have selected the 'Name' field from the cust/suppliers table (for the bought from) that field dissapears from the dropdown box in the wizzard, so how do I then select it again for the (sold to).
Hope this makes sense....
The lower tech the better solution for me as I am still finding my feet with Access, but loving the experience.
Thanks
Last edited: