Customer with multiple visits.

[cotto1968]

Hi all,



I've created a form and everything seem to be going good when I found one of the customers has more visits to the shop and I don't know how to be able to put the extra Dates the customer has come in without having to fill in an entire form for the customer. All I want to do is to be able to enter as many times the customer has come in. For example, the one customer came in on the date 3/14/14 then on 4/21/14 then on 5/3/15. How can I add the dates without having to create a new form for each visit?


Thank you in advance

Julio

[CJ_London]

sounds like you need to google 'normalisation' to understand how databases are constructed

you need two tables, one for customers, one for visits. The visits table would be something like

tblVisits
VisitPK autonumber
CustomerFK long - link to tblCustomers
VisitDate date

you would create a very simple continuous or datasheet form for tblVisits (only needs the visitdate column displayed) and place it on your customer form as a subform

Ensure the linkchild and linkmaster properties of the subform control are completed with customerFK and customerPK respectively

You haven't provided any names for your fields, so the ones I have used are the sort of thing I would use - replace with your names as appropriate.

[orange]

You might try watching some free video tutorials by Dr.Daniel Soper that will help you with the concepts.

Intro to Database
The Relational Model
Data Modelling and the ER Model


Good luck

[cotto1968]

Thank you very much for the advice I will put it to work. But first I'm going to watch the free tutorial videos by Dr. Daniel Soper so I can understand it better.

[cotto1968]

Thank you very much for the advice I have already begun to watch the videos... again thanks!