I have a table called Main, that is comprised of columns that have lookups to other tables ex. Application column foreign key is linked to Application table primary key. The Main table's only unique column is the MainID column which is an identity field. When I create a stored procedure it shows the Primary keys for all of the tables it is looking up to, instead of the value ex. for Application it shows 18 instead of Quick Books. If I join the lookup tables to the main table it all works out OK.
Problem: I need to create an update query to make changes to the Main table, and I can't make changes to it, since I can only specify a single table in an update query. It is also saying data mismatch type, since I have decimal specified as datatype for all lookup columns.
Problem: I need to create an update query to make changes to the Main table, and I can't make changes to it, since I can only specify a single table in an update query. It is also saying data mismatch type, since I have decimal specified as datatype for all lookup columns.