Hi there,
I have one Vendor table which has field VendorID (primary key) and field VendorName. And two other tables
table 1 : product (which has VendorID as foreign Key)
table 2 : salesman have VendorName field also.
say for example : (from Vendor table) VendorID : 1 VendorName : Dell
VendorID : 2 VendorName : Dell
Now Product table would be have different product associate with VendorID since they link by VendorID (primary-foreign key)
VendorID 1 : productName: memory
VendorID 2 : productName: paint.
different VendorID carries different product
And salesman table suppose to be link by VendorName in Vendor table
VendorName: Dell SalesmanName : Mr. A
VendorName: Dell SalesmanName : Mr. B.
Mr. A and B works for same vendor so it must appear in both vendor. The reason why this structure this way because Dell may be in diffrent location of the country and Mr. A lives in diffrent location with Mr. B. (for search purpose i want to be able to see salemans from searching for VendorName) etc...
when I'm in view mode I can see a link to my product table which displays all the product of a particular Vendor sale so it's good. However I trying to have another link to Salesman table which will display all the salesMan who work for a particular Vendor. Is this possible. ?? salesman and vendor linked by VendorName field.
Is there any way can i make the pages more interative (drop down list, rearrange fields to specific places) , and can i have drop down list in add mode so when user enter data, they just pick the entries in there to add it faster. Can I also have two table in one add page the user don't have to move back and forth. THanks alot for your time.
Your product is off the hook:)
