Subject Unsure of editablitly in join select
Author Ryan Nilsson-Harding
Hi there,

I have a table which has three fields; PART_ID, USER_ID & QTY

This table is used to maintain the qty of certain parts in different
users locations.

Now, I would like to be able to edit this table directly, by
allowing the change of the QTY and PART_ID fields. As PART_ID is a
FK to the parts table, I obviously want the end user to see the
actual PART_NUMBER (not th ID), so I'm using a join to display the
data accordingly.

My joined select statement is not updateable, so I'm having to find
another way around this.

Is using a IB_LookupCombo in the grid to display the part numbers a
bad way to do this?
At the moment, the part table has around 2000 records, but this will
eventually be around 10,000 records.

I am just wondering if this is a poor design because of the size of
the part table, or if there is another way to allow the join query
to be updateable.