Joined: 23 Mar 2010
|Posted: Tue Mar 23, 2010 6:56 pm Post subject: Data posting
|I'm trying to set up sub-forms which allow the list box selection from a View. I've been able to set the form so individual selections can be made, but when I check my tables it doesn't appear to post on the intermediate table.
[various unrelated fields]
The View is:
SELECT "Name"||', '|| "Type" AS "Skill", "ID" FROM "Skill" ORDER BY "Name" ASC, "Type" ASC
Employee employee_skill Skill
ID 1..n employee_id n..1 ID
skill (skill view)
This is my 1st attempt at designing a database, so if you could 'dumb down' any information I'd really appreciate it.