Dlookup??

[DPThomas]

I have a form that has lets just say an item number description, in another hidden field I have a Dlookup to lookup in a seperate table the description for this item number (for reference purposes only), on exit of the field I run a refresh to update the Dlookup, is there some easier way to do this via code of some sort. Item # field is called W1Yarn Description is called W1Desc (which is visbile upon exiting W1Yarn) and I have about 12 of these types of fields.
The problem I am having with the databse is that when someone is entering a new record it comes up with the error that someone is already editing that record or is currently editing that record and am wondering if the refresh is causing this problem.

Thanks for Your Help
Dave Thomas

 

[dcx693]

Unless you have a very good reason to, you should not be using Dlookup for this. If the item description is in a separate table, why not join that table to your existing table in a query to feed into your form? Then you'll have the item description available.

 

[DPThomas]

Dlookup

I understand what you are saying, however I need the description to show up immediately after they enter the item description, the item description is in a table called yarns, the item # is in a table called styles. The form I am referring to is using the records source of stlyes. Is there a way of doing this easily without the use of DLookups.

Thanks
Dave Thomas

 

[dcx693]

What I'm trying to get at is that if you can combine tables that contain the item # and item desciption into one query, then you can use that query to be the recordsource for the form. The tables have to be joined logically, however.

You mention that the styles table has the item # and that the yarns table has the item description. The styles table obviously does not have the description. Does the yarns table have the item # as well?

If yes, then you can join the tables on the item # field in a query, and use that query to be the recordsource for your form. If no, then there must be some other way to relate these tables to each other. How do you know which item # goes with which item description?

 

[DPThomas]

Dlookup

Hi thanks for your help first of all

The item number does reside in both of the tables the actual Item # so to speak is a yarn number and each 'style' can use up-to 13 of these yarn numbers in an individual style... The reason for a Yarns Table and a Style Table.

For example
8783-61 Style
F Yarn 1 =1028
F Yarn 2 = 2057
F Yarn 3 = 1289

W Yarn 1 =1028
W Yarn 2 = 2057

F Yarn 0r (filling Yarns) can be up to 4 different Yarns
F Yarn or (Warp Yarn) can be up to 9 different yarns

hence the problem that occurs with trying to set up relationships between the tables.

Again thanks for your help in this matter, I just seem to be missing something that I feel is going to end up obvious in the end