Newbies Phil1 Posted February 23, 2006 Newbies Posted February 23, 2006 I am having difficulty creating relationships. have defined the relationship to the master file on the unique record number. However I am unable to see all of my records. I do a find but my records do not appear. I think I need to create a portal, but I am lost. Can anyone point me in the right direction? Thanks, Phil
Wim Decorte Posted February 23, 2006 Posted February 23, 2006 You need a portal if you want to see the related records when you're on a parent record. Otherwise from the parent record, you can script a "go to related records (show related only)" to produce a found set in the related table. Can you post a screenshot of relationship definition?
Genx Posted February 23, 2006 Posted February 23, 2006 You defined the relationship to be primary key in your parent table to foreign / related key in your child table? Are you sure your child table has corresponding foreign keys? ~Genx
Newbies Phil1 Posted February 24, 2006 Author Newbies Posted February 24, 2006 Thanks....I would paste a screen shot of the definition, but can't get the print screen to function. The way I set it up was to open the file I wanted to reate the realionship. Linked it to my Master/parent file -- and used a field in my parent that has unique values (record number). I have tried to make sure that both fields in the parent and the child files are exactly the same. Still having problems though. I think I know how to set up a portal. Running a script is a little beyond me at the moment. Any further help will be greatly appreciated. Phil1
Recommended Posts
This topic is 6880 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now