CraigDolphin
GrumpyOldMan in Training
- Local time
- Today, 10:36
- Joined
- Dec 21, 2005
- Messages
- 1,582
Sorry Colin. Have been struggling with another thread and hadn't checked back until now. Have attached a 'fixed' version.
Basically, the issue was that your Setr field in the invoices table was using a lookup combo and storing a text string in the field. The combo on your form was storing the numeric ID of a record in the SETR table. Comparing a text sting to an integer results in no match. Storing the text string also violates normalization principles.
So, I added and populated a true SETRID field in your invoices table and made it required. I then deleted your old SETR field and re-joined the relationship between the two tables. I went through your queries, reports and forms and did my best to re-connect everything that needed reconnecting. If you find any references to SETR ID (with a space) these are actually referencing the SETR field (text) from your SETR table.
This should hopefully fix your problem for now.
And AJE, sorry if I stepped on your toes....just thought I'd chime in since you indicated that you wouldn't have time to look at it yesterday.
Basically, the issue was that your Setr field in the invoices table was using a lookup combo and storing a text string in the field. The combo on your form was storing the numeric ID of a record in the SETR table. Comparing a text sting to an integer results in no match. Storing the text string also violates normalization principles.
So, I added and populated a true SETRID field in your invoices table and made it required. I then deleted your old SETR field and re-joined the relationship between the two tables. I went through your queries, reports and forms and did my best to re-connect everything that needed reconnecting. If you find any references to SETR ID (with a space) these are actually referencing the SETR field (text) from your SETR table.
This should hopefully fix your problem for now.
And AJE, sorry if I stepped on your toes....just thought I'd chime in since you indicated that you wouldn't have time to look at it yesterday.