Hi folks,
I am looking for a solution to the following if anyone can help. I have inherited these tables from an existing Access database.
I have two Tables which contain the main Data sets as follows: -
tblsupplycategoryv2
SupplycategoryID key field
SupplyCategoryName
SupplyCategoryShortName
SupplyCategoryTypeID
SupplyCategoryFormatID
tblsuppliersv2
SupplierID key field
SupplierName
Switchboard Phone
SwitchboardFax
SupplyType
The relationship between the two tables is defined in a third table: -
tblsupplierssupplycategoryv2
SupplierID
SupplyCategoryID
The relationship between tblsuppliersv2 and tblsupplierssupplycategoryv2 is One to Many and the relationship between tblsupplierssupplycategoryv2 and tblsupplycategoryv2 is Many to One
What I want to achieve is to go from the menu to display List/Add/Edit etc. the fields I require from tblsupplycategoryv2 and then have a link to child table tblsupplysuppliersv2 which would then display the records pertaining to the record in tblsupplycategoryv2 .
I thank you in anticipation of a suitable solution.