I have created 3 tables in my data base, one supplier table holding supplier names and contact details, a parts table holding part numbers, descriptions, prices and lead times etc and a jobs table holding information about the different jobs, their descriptions, serial numbers etc. I want to create a report which displays the part number and what supplier supplies it. How would i do this? I cant seem to get the relationships right!
Any Help would be appreciated!