How a Synonym works in APEX
567811Oct 22 2008 — edited Oct 27 2008I have been trying to set up a table for users to Insert, Update, or delete. This table is in a synonym from another schema and I can't get it to show up how I would like so that the users can modify the table.
When I look at the synonym from the Object Browser, I can not see any fields, Is this Correct?
I would like to show the fields for this table in a tabular form for update, but the forms only accepts tables unless you use a SQL query, Is there a way to show a synonym's fields in a form for Update, Insert, or delete?
Whwn I use a sql query for the synonym, no values shw up when I run the form, any reason why?
Thanks
Rob