Hey Guys

Great Forum and another newbie here

I have created an invoicing system for my business, as i was unhappy with MYOB.
Basically i have Product ID and Desciption in 1 table.
In another, called registry, this is where i input the data for the order.

What i basically want to do is?
When i type in the Product ID in the registry table, i want the description field to automatically appear in the cell next to it. As this would save a lot of time

Any help would be much appreciated

Thanks

Tarek

You have the right idea, but in the wrong place. You don't need to copy the description to another table, just the ID. When you need the description, you join the two tables in a query. Also, you don't enter data in a table in a well designed system. Tables are for storing data, forms are for entering data.

You have the right idea, but in the wrong place. You don't need to copy the description to another table, just the ID. When you need the description, you join the two tables in a query. Also, you don't enter data in a table in a well designed system. Tables are for storing data, forms are for entering data.

Hello

Thanks for the information. Would you have any further information on how to do the query for this?

THanks

Tarek

Hello

Thanks for the information. Would you have any further information on how to do the query for this?

THanks

TarekIf you tell me what the tables look like...