Hello there! I developing a database simple enough for my friends to use using ACCESS. I wanted it to be only one Table only. The fields I want to play with are: TrackID, Member_Lastname, Member_Firstname, IDcolor, IDnumber, ReferredPerson_Lastname, ReferredPerson_Firstname, RPIDcolor, RPIDNumber.
I created a dropdown combo for each on the form so I could see options as I type the names. What I wanted to do is how to AUTOFILL IDcolor, IDnumber when I selected/Type the Firstname and Last Name, meaning the two should match first before the fields IDcolor, IDnumber should autopopulate. The same thing with RPIDcolor and RPIDNumber, when the correct names and lastnames are typed on ReferredPerson_Lastname and ReferredPerson_Firstname.
Is there a way to do this using only 1 table or I have to split it up? I am afraid that in having more tables, if an entry is deleted on one table, the matching might messed up and will be a disaster for them (and for me) that is why I wanted it only 1 table.
pcnovice
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.