Re: [MSAccessProfessionals] Form not working as expected

Thanks for responding Bob.

Refer to my inline answers below

On Friday, May 8, 2020, 03:42:25 AM GMT-4, accesspro@gmail.com <accesspro@gmail.com> wrote:

"date field to record the date the customer comes in."

Do you mean visits or is entered in the db ?    Visits

Will there be multiple entries for a customer in the date table ?  Yes.  The customer can visit multiple times but not on the same day.  Customers can only visit once per day

 

Bob

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of toukey1 via groups.io
Sent: Thursday, May 7, 2020 9:07 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Form not working as expected

 

I am building a small database to capture basic customer information.  I created a table called tblcustinfo with the following fields:
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