Adding new record to Child info only in a view 1

[foxrainer]

having a one-to-many view derived of two tables, how do I add a record to the 'Many' table and not the primary?

Example:
table One - fields Code(primary key), name
table Many - Fields many_Code (primary), one_code, some_date

View relates table one and many by Inner Join Code=Many_code

Now, how do I add a record to table Many without adding a new record to table One? Wouldn't 'Append Blank' also add a record to the parent table?

Thank you in advance
Rainer

 

[fluteplr]

You can't unless you want to set table one to not be updatable at all from that view.

I would not recommend doing it this way. I would have one view for the 'one' table and a paramterized view for the 'many' table.


If you want to go the not updatable route. You can set only one table to be updatable by using dbsetprop to change the tables property. NOTE: If you change the view after that in the view builder it will change it back to both tables being updatable. (At least in 7, they may have fixed this in 8).

 

[foxrainer]

thank you very much

Rainer