Using a master list?

[hihofink]

&nbsp;&nbsp;I have around 2,000 style nubmers, with information of their content and description created in a table that is used as a master list.<br><br>&nbsp;&nbsp;Currently when I update the inventory I create a new table, and type in the newest style numbers&nbsp;&nbsp;I then manually look at my master list and type in the content and description, one by one.&nbsp;&nbsp;&nbsp;Sounds silly, right?&nbsp;&nbsp;Here's the catch.<br><br>The master list only has a four digit stlye number, such as 1234.&nbsp;&nbsp;While the style number that I input when updating the inventory is longer.&nbsp;&nbsp;To show color I add a backslash and a number from 0-9 to the style number, such as 1234/0.<br><br>So how can I make the despcription and content columbs automatically update themselves through the master list based on the first four digits of the style number I just put in.<br><br>Any help will save me hours...<br>Thanks<br><br>Joshua Fink<br>MAGNA FABRICS <br><A HREF="mailto:hihofink@hotbot.com">hihofink@hotbot.com</A><br><br>

 

[rochelle]

Why not change your inventory table so that the style number is made up of two columns: the four digit style number that matches the master table and another column that shows the color.&nbsp;&nbsp;Your key in the inventory table can be a combination of the two columns.&nbsp;&nbsp;You can make it print on any reports the same way it prints now simply by printing [Col 1] & &quot;/&quot; & [Col 2].&nbsp;&nbsp;This way you can join your inventory table to your master table on the four digit style number and automatically update the relevant fields in your inventory table using an update query.

 

[hihofink]

Thanks... Your advise was very helpful<br><br>-Josh<br>