I must export the Access DB to flat files for my internet DB. The first flat file is the Master form, and the secondary flat file is from the subform.

When the data is exported to 2 flat files, there is "NO" indication in the Master flat file that subform records exist in the subform flat file for that specific Master record.

I need a "switch" indicator field set in the Master records indicating the presence of
a subform record. This would be "set" prior to exporting to flat files.

Any ideas? E-mail me at bgandy007@aol.com
Thanks

Use a query to export the parent table. The query should join the parent table to the child table. Select all the columns from the parent table but none of the columns from the child table. Add a Count(*) and group by all the columns from the parent table. The count field will be > 0 whenever there will be related child records to export.