Hi,

Its my first time posting here and I could really use a hand!

I'm used to using relational databases such as MySQL as I do a lot of dynamic database work for websites using PHP. I'm now trying to get used to working with FMdev 7 for a major project.

The problem I'm having seems really silly - I just can't see how to enter a new record across multiple tables at the same time.

Essentially there is a main table I've called 'students' and three other tables for 'students_group', 'students_type' and 'students_sex'. In these other tables I have a copy of the primary key from 'students' called student_id. I want to see how FM7 allows data input across these tables, making a copy of the 'students.student_id' value in the other tables and allowing all data to be entered in a single layout...

Sure this may be quite a simple thing but I'm finding it a little frustrating!

Cheers,

Dan

Here's a very simple example.

I have turned on "cascade create" on the relationships, and FM will copy the studentId to the other tables as needed to create them. Double-click on the relationship boxes in the graph to see all the choices available.

Hi Shadow...

Yup, I see what you mean. I have since posting found this but am still having problems.

I have it so that the student_id is now copied, which is great. FM doesn't seem to want me to add data in any fields from these other tables for some reason. It insists that the relationships are invalid or, if I can get one field to accept input, it won't allow entry in any other. I've tried doing this with either just regular fields or using a portal with no luck.

I just hope The Shadow knows...

Cheers

Could you post an empty clone of your database so we can look at it?

Aaarrgghhh!

It is actually surprisingly easy to do this. How foolish do I feel now? Think I was getting confused with the way FM works compared to the RDBMS that I'm used to - its a different way of thinking a lot fo the time...

Thanks for the help Shadow!