Relational Table or something else?
I wondered if someone could point me in the right direction.
I have a site created in DataAssist for a dog breeder. They list breeding references, puppies and numerous other related records. I'm needing to connect some of the data from different tables. I'm assuming this is Relational Tables. But I'm still reading on this subject. As it relates to DA and any other WA product, what would be my best approach?
Here's a simplified scenario of what I already have.
1 database with 3 tables;
Table 1= Breeder males (tblMales)
Table 2= Breeder females (tblFemales)
Table 3= Puppy birth records (tblPuppies)
I then have 3 display pages on the site with repeat regions, showing all records for the subject. This is all working fine.
Now I need to create a 4th page that shows breeding/mating schedules.
Male1 is paired with Female2, bred on such and such date, expected delivery on an other date and so on.
And ultimately, join the puppies to their parents.
I have an admin section created for the user to Insert, Update and Delete all current records above.
How do I join them so that they can list one male from the males table and one female from the females table and show it on the "Breeding Schedule" page?
Since all the breeders have been entered and include 1 photo, it would be great if I could setup a simple table that includes the name or number for a male and a female and then joins them on that page while including their current photos from the other tables.
I'm guessing I would use Dynamic Drop-downs to dynamically generate a list on the Insert page for selecting a male and female that already exist in the database. But I'm confused on getting started. I read the area in the DA Help on the subject of creating a Relational table, but I got lost.
I don't mind doing my studying, but I just need pointed in the right direction. I don't find anything in the DA Wizard for including such a behavior.
Thanks in advance,
TroyD