Search results

Thanks for your help...I don't suppose there's a way to do it without learning VB? (Go and buy Filemaker Pro? :) ) No box I can simply tick in a wizard or something? Thanks, I am ascending the hill of Access slowly :D

I have a main form, and I was hoping that the data I enter into a particular field ("UR" which is the primary key of the main form) appears in other forms linked by a command button. There is a relationship created btwn these two forms, linking the field, and it works OK with subforms ie. when...

Think I sorted it out. Need to have different primary keys for each table? Now I have a different issue :rolleyes:

Thanks but that didn't work. What I am doing is: Created one table with a primary key called "UR" (6 characters), and other fields such as name etc. Created a second table with the same primary key called "UR" (I gather all tables should have a primary key) where I enter dates. I then created...

I am a newbie to Access, & have a reached an impasse. I am trying to design a form in which you can enter basic ID details of a patient, and then in a subform enter billing details for multiple consultations on different dates. Really simple, but each time I try to enter a second record in the...