Search results

Does anyone know if this can be done? Or maybe have mulitple yes/no checkboxes, and if it's a yes, a combox appears next to it to select let's say a doctors name and so forth? Joe

Question 2 and 4 is a no. My guess is question 3 will happen rarely for the client. Number 1 is a yes. That is why i split the addresses up into different role tables. I hope that willl work ok. I came with this design and if you have a chance maybe you can critique it. I have 2 questions...

just out of curiousity. would it be possible to put the address in the detail tables, since they are different types of addresses? and take out the tblPersonroleaddress table. Along with the business address i can put the business name, and the same goes for clinicname and it's address for...

I am not sure i understand. i attached my relationship so far and maybe you can see if i did it correct. I will also be having different multiselect listbox's for each type of role and wondering how you would implement that so when you enter the doctors information, only the doctors listbox...

Thanks Pat for all your help so far. Do you think this is the way to go about it? Is there a better way? What really puzzles me is how i'm going to create a form for this, will i need a form with 2 sub forms? I am going to create 3 different types of forms for each type of individual linked...

tblPerson -PersonId (PK) -LastName -FirstName -MiddleInitial -Title -DoB -Gender -MaritalStatus tblPersonRoleAddress -PersonId (PK) (FK - tblPerson) -PersonTypeId (PK) (FK - tblPersonType) -Street -City -Province -PostalCode -Email tblPersonType (going to be a lookup) -PersonTypeId (PK)...

thanks for your help. Steve, that's what the tables (tblClientDetail, tbldoctordetail and tblbusinessdetail) do, each having unique fields that do not belong to tblPerson. I created a 1 to 1 relationship with those and it seems to work, but it's not future proof when it comes to people having...

Hi, i run into a problem deciding how i am going to go about this as i am just learning access. Here it is, it's for a nutritional company. I have 3 different types of clients (Average customer, Doctor, Business Contact). Between these 3 clients they have some similar fields and some...