From Design Problem

Score
0
Vote Up
September 25, 2006 at 06:09:15 Pacific
Specs: XP SP1, P4 640 / 1 Gb

My first try on a relational database!

I created an Access 2003 database with two tables, linked by a one to many relationship. I created a form based on a query with both table details. The form enables access to a data field from the related table (the one in the relationship) via a combo box.
This works fine. However, I have trouble to display on the same form other fields form the selected record.

This might be trivial to many, but I really would appreciate some general direction on fixing this.

Regards, Wilfried


Reply ↓  Report •


#1
Vote Down
Score
0
Vote Up
September 25, 2006 at 09:05:23 Pacific

Did you base your form on the query? Have you added those fields to your form using the form field list?

Life is more painless for those who are brainless.


Reply ↓  Report •

#2
Vote Down
Score
0
Vote Up
September 25, 2006 at 16:00:05 Pacific

Yes, I did. Regards, Wilfried

Reply ↓  Report •

Reply to Message Icon Start New Discussion
Related Posts

« SQL Server statement Anyone good with Veritas ... »

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Ask the Community!
Describe your Problem
Example: Hard Drive Not Detected on My PC