Hi all, im pretty new to this and have a problem im stuck on.

To give you an idea, i have three tables. a client table, a shop table and an orders table and a corresponding form for all of the tables. a client or a shop can place an order via the orders form. therefore what im trying to do is via the orders table have two combo boxes where the user first selects the "Type" ie a client or a shop which are defined as typeid 1 for shop and typeid 2 for client in a fourth table, when a new shop is added to the shop table the entry is auto assigned id1 when a new client is added to the client table the entry is auto assigned id2.

on the orders form, based on the selection of either "shop" or "client" from the first combo box the second combo box should go to either the shop table or client table and populate the second combo box with the list of contacts from either the shop table or client table.

like i say im pretty new with all the code stuff so struggling a little on this one, any help would be great!

Thanks