Sesame can do a hierarchical import. This capability is specifically for the purpose of automaitcally creating form/subform relationships on import. See pages 342-344 in the 1.1 User Guide.

Access does this easily when you run a query that uses values from both the parent and the child records. It is the default behavior to "flatten" the relational data into the format Sesame wants to import. I don't have a copy of Access in front of me to give to step-by-step directions. Perhaps someone else does.

Hi -

I MUST tell on MYSELF because I thought this was so funny. I am so proud of  - and am doing additional work on - my CD database.

Then, starting yesterday and this morning I thought "oh no, now what is wrong with this thing?"

I have 49 CD's entered so far.  But as I would work on my forms - and I glanced at the form # - it would change seemingly without any rhyme or reason.  Suddenly, instead of being on form 2 of 49, I would be on form 2 of 15 and I thought "oh no, did I lose my records?"  

Then I would be on the second form and click on advance to next form and no matter how many times I clicked, I would still be on the second form (even though at the top, it would advance to form 3, 4, etc.).  I thought I was going to have to ship another database to Ray to have it checked out.

And then suddenly I burst out laughing.  It took me all that time to realize that the "counter" at the top of the form was properly responding to the correct form # and total # of forms DEPENDING on whether I was on the MAIN form or the SUB form.  

So, I can now go back to simply enjoying and being very proud of my foist databse with sub-forms.  Once again, I am extremely impressed with how simple and easy-to-use this function is.  Congratulations, again, on some incredible design work.  

On that note, all I can say is: