custid (primary), custname, custaddr, custidnum. I built a query on this table and then a form based on the query. On the form I have a combobox for the name field so that I can select the customer name and the other fields are populated correctly. So far so good!
Then all hell broke loose when there was a need for a date field to record the date the customer comes in. This is where I am stuck. I created another table called tbldaterec with the fields dateid (primary) and daterec. I added a dateid field in tblcustinfo and did a joined the tables on this field. Am I going correct? I amended the query to include the new table and daterec field. However when I included the daterec field on the form, my combobox no longer works. Got an error like joined field not in recordset.
What I am trying to accomplish is when I open the form I select the customer from the combobox and it automatically populates besides the name, the address and idnum (this was working fine until I added the date field). The date field is not to be automatically populated.
Where am I going wrong?
Regards
Mercy
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#115489) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar