OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Data posting

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
tominator7
Newbie
Newbie


Joined: 23 Mar 2010
Posts: 1

PostPosted: Tue Mar 23, 2010 6:56 pm    Post subject: Data posting Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group