I've just inherited an Access database and application which needs modification. I've programmed with Pdox for 10 years, so Access has some frustrations associated with it. Does anyone know how to create a 1->M form where there's a 1->1 lookup (display) on the many side of the form? I've successfully created a subform, but what I want is for an ID number to show its associated description on the child table (which shows many records). Seems difficult in Access, while it's simple in Pdox.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Paradox vs. Access forms
- Thread starter sonso
- Start date
Access does not meet as many of the criteria as Paradox for matching the relational model. I am not an Access user, but I have heard that some things we do in Paradox are beyond its scope in terms of relational links. Mac 
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
- Thread starter
- #3
Turns out, you put in a calculated field and it will display. There are definitely some funky but interesting aspects to Access. For instance, I just used the lookup function in Access which allows for a multiple column display of the lookup (via a query, so you don't see an entire table), uses the primary key in the underlying table, but displays the associated field contents onscreen. It's kind of neat.
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question