Search results

Thank you Pat! It is interesting piece of DB. Gave me different ideas and ... more questions! :-) But you are right. I have to make sense of it for myself.

Hi arnelgp, I tried hard to see mechanics of the form in your DB. I can see how particular fields on the form are connected together, but I can't see how data are linked to table Trainings to be stored. Hopefully the last question in this subject. When you start a form, do you use any Access...

Hi arnelgp! You did fantastic work for me. Eye opening example, not only from technical but design as well! :-) It is shame there is only one Thanks button per answer. You deserve more! It will take me a while to decipher your project, but I already know that the answer is there. Thank you...

I try to populate table Trainings with data. Why should I touch other tables?

I left links as suggested by Access - ID in both cases. ID refers to Trainings.ID as far as I can understand. I wander why you have said "odd" and what do you mean by "The main form should be passed on your Person table". When I created initially this form in Access 2016 it was working fine...

I am not stubborn with the solution I presented in my initial post. If there is a method of entering data to one table using one value once and add other values ... It can be described opposite, few values for particular training once and add names of attenders. I have read few treads from this...

I tried this. The error message is that I want to make duplicate entries.

Hi, I am new and I can't find search option on this forum. If I ask previously asked question the reason is I don't know how to search here. I use Access 2010. My dream is to solve this: I got one table called Trainings which stores mainly numeric ID's. There is PersonID, TrainingID, TrTypeID...