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

Need Help w/Listbox and Relation in Form

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


Joined: 30 Dec 2006
Posts: 2

PostPosted: Sat Dec 30, 2006 4:35 pm    Post subject: Need Help w/Listbox and Relation in Form Reply with quote

I am trying desperately to create a form that has a list box which references information in another form. I'm building a contact management database and need to normalize company names of my contacts. I created a form in the form wizard and then added a list box in design view that displays the info I want correctly. However, when I try to edit records (or add new records), every time I save a record the data I've selected in the list box gets erased and the drop-down list box goes blank.

Any suggestions on how to fix this?
Back to top
View user's profile Send private message
remdelyon
Power User
Power User


Joined: 11 Sep 2006
Posts: 62
Location: Lyon, France

PostPosted: Thu Jan 04, 2007 9:42 am    Post subject: Reply with quote

Hi,

seems that your problem comes from the way you have created the relationship between your contact table and the normalized company names table.

have you created a proper relationship like described here:
http://www.oooforum.org/forum/viewtopic.phtml?t=45977&highlight=
_________________
Ubuntu / Vista - LO 3.4.3
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