tominator7 Newbie

Joined: 23 Mar 2010 Posts: 1
|
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.
Skill:
ID (pk)
Name
Type
Employee:
ID (pk)
SkillID
[various unrelated fields]
employee_skill:
employee_id
skill_id
The View is:
SELECT "Name"||', '|| "Type" AS "Skill", "ID" FROM "Skill" ORDER BY "Name" ASC, "Type" ASC
Relations:
Employee employee_skill Skill
ID 1..n employee_id n..1 ID
Forms:
Master (employee)
emp_skill (employee_skill)
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.
Thanks. |
|