Access multiple columns same name? -- beginner

[zubair.s.kazi]

guys i really need this for my school project okay so... ive got multiple columns for the CFName on each tbl... My question is how can i create a query which will list all the customers with supplier id SP102.... Plzzz Help Guys

[rivereridanus]

I hate to tell you this, but it's not going to work. Your database is fundamentally set up to not support this. You seem to have organized the db the same way you would for an excel spreadsheet (which is more intuitive), but an access db doesn't work like that. You need different tables for Supplier, Customer, and Item (not separated by laptop, cellphone, etc). Then make tables to link them such as Order to link Customer and Item, and Order Line to link Supplier and Item.