Thank you for your post.
I understand how the three tables are interlinked, but how do you want the data exported? That is, do you want the father, mother and kids in one record? Or, do you want father, mother one kid in one record, and any other kids in subsequent records?You may need to create a script to export the data in the desired format.
tsGAL, The database is used for a dog breading organisation. There are some important things that need to be done.
The export should go to a plain ascii text in the following way:
The nest number,
With info about the nest like dat of birth and how many kids (male female) from Main
each nest has one mother and one father (Both from the parents database)
Each mother and father are a nest, (this numner is the glue between all the mothers father and kids) this nest has a descrtiption on the quality of the nest. (main)
Unther this data all the kids present should be listed.
I get everything workng in the preview print mode, but i cant get it to go to an ascii file.
Also i cant make the print version to use only the amount of spaces based on the number of kids. As you can understand
not all families are the same size. sometimes 12 kids sometimes 2.
Last but not least, in the final report i need to omit the kids that where not tested or reported.So there is a chance that i need to do a find on a field (absent yes/no) then omit these kids and parrents.
As you can see as a newbie i got myself in a nice twist :)
Hope this helps a bit
When you export to an ASCII file, a dialog box comes up to specify the field order. At the bottom, there is a check box to:
Apply current layout's data formatting to exported data.
Be sure you use the same grouping that you used in your report.
When you export, what isn't working properly? Are you getting the father and mother? Are you getting one or more kids? Are you getting all the kids? I need more information on how the report is set up.