associates
Registered User.
- Local time
- Today, 11:08
- Joined
- Jan 5, 2006
- Messages
- 94
hi
I need help here. I've been trying to fill in the textbox with some data in the report but it just won't let me assign a value to it.
What's happening is i have two tables, tableA and tableB. The report is based on tableB however there are some fields such as contact, phone, reference that are empty in tableB that can be filled in by looking up on tableA. I know that i can link the two tables together by ID or something but i'd rather do it this way to avoid duplicates
My question is as soon as the report is open, i need it to check if the contact field is empty or null, then look up tableA to retrieve the value of contact and then assign the value to the textbox created for contact in the report.
Hope that i don't confuse you.
Your help is greatly appreciated
Thank you in advance
I need help here. I've been trying to fill in the textbox with some data in the report but it just won't let me assign a value to it.
What's happening is i have two tables, tableA and tableB. The report is based on tableB however there are some fields such as contact, phone, reference that are empty in tableB that can be filled in by looking up on tableA. I know that i can link the two tables together by ID or something but i'd rather do it this way to avoid duplicates
My question is as soon as the report is open, i need it to check if the contact field is empty or null, then look up tableA to retrieve the value of contact and then assign the value to the textbox created for contact in the report.
Hope that i don't confuse you.
Your help is greatly appreciated
Thank you in advance
