Correct relationship not created when using menu?



Well Murray, thanks a lot for the feedback!

    i started again, creating just a Patients table and then using the gui to create the related table & relationship.  i then created a few fields for the newly created, dependent table, Visits.  i then went in and using Patients, created a layout which contained fields from both tables. 

This time i was able to input data into both tables, but upon examining each table, the only fields available were the original ones that Glom creates when it creates a table, i.e. the Comments, ID and Description fields.

In layout view, i could go back to the new records of the Patients table, but nothing that i had typed appeared in the Visits sub-table.

Upon examining the Relationships i saw that Glom had not created anything in the From Field.  i don't know if this is correct or not but...

When i examine the Visits table, i see that it now has some 9 records while the Patients has three, which is as it "should" be since there are normally more visits than patients :D

So, i'm still experimenting...

Have a great evening!  :)



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]