Search results

Pat, Thanks for directing me to the DB info. I appreceiate your help and if you know of any other sites you think might help me on this please pass them along. Thanks again Cindy

Pat, Can't I maintain my referential integrity by forcing the Primary key in my grandparent table to always start with say 5 and my parent to always start with a 1? I know that may sound dumb to you but...I am used to having to tell the computer exactly what I want it to do with my data and if...

Pat, I do have that extra field in the relationship table so that I can link the Parent and/or grandparent to a child. The extra field is based on a table that has parent, grdpar or sibling. Should I put all the children in the child file and because they would be linked to a parent, use the...

I have made some forward strides but here is another question. I have now set up 4 tables as follows. Parent Table: ParId ParFstNm ParLstNm +other info Student Table: StuId StuFstNm StuLstNm +Other Info Grandparent Table: GrdID GrdFstNm GrdLstNm +other info Relative Table: RelRecTyp RelID...

Pat and David, Thank you for your responses. I think I get it now. I know on our files (tables), at work, we create a unique key structure and I did start out that way with these fields but changed them grasping at anything to try and make this work! So based on the info I need for child...

Pat, Thanks for your response. I am still a little confused...could you explain why what I did doesn't work? How is what I did different than your example. I have: ChildTbl ParentTbl ChildTbl_1 Par1LstNm ------> ParLstNm <----- Par2LstNm Par1FstNm ------> ParFstNm <-----...

Jennifer, Thanks for your reply. Technically I do have one Parent file. I have a child file with the following: child 1st Name (key) Child last name (key) Par 1 1st Name (required) Par 1 last name (required) Par 2 1st name (only if parents divorced) Par 2 last name (dito) + other data The...

I am trying to learn Access and have run into a couple of things that I may not have done correctly. I have created a Student table with the student first and last name as the PK. This file also contains Parent 1 First and last name and Parent 2 First and last name (parent 2 info will only be...

I also have a question regarding subforms. I am trying to learn Access and have run into a couple of things that I may not have done correctly. I have created a Student table with the student first and last name as the PK. This file also contains Parent 1 First and last name and Parent 2 First...