Properly creating a form without using a subform

[BigO56]

I am currently building a database for applicant submissions.
Current tables consist of:

Personal Information
Personal ID (PK)

One to many relationship

Position Applied
ID (PK)
Personal ID (FK)

Within my form I am using the [position applied] for table as a subform. The problem I am running into is that I do not want to use a subform for this function and I would like to link a text box to each position applied for. Currently each text box that I have open is only linked to the first record within [position applied]. Is this possible, and if so how can I link the text box to the specific record in position applied for.

[jforbes]

There are a lot of different ways you can approach this depending on what you are trying to accomplish. With the relationships you have defined, people tend to go with a SubForm as that's pretty much what it's made for. So what is it that you are trying to accomplish?

• Displaying the last position applied for?
• A Single textbox with all the positions applied for listed, separated by commas?
• A list of records of positions applied and the date applied for? (pretty much a shoe-in for a SubForm)

[NeoPa]

I'm afraid it's hard to understand what you're asking for. I'll guess :
Are you saying you'd like to see the linked records in continuous form mode in the Detail section of the main form?

[BigO56]

Thanks for the response, my problem is due to the position applied being the many in the relationship. To properly display all of the positions that the person applies for has to be in a subform. The user that I am creating this database for does not like the layout of the subform and prefers the look of textboxes. My goal is to display each position applied for in textboxes, as if it was in a one to one relationship.

I hope that I am properly conveying what I am trying to do, if not I can draw it out so that you all can see.

[jforbes]

If you want to roll up all the positions applied for and put them into a single TextBox, you might want to look at this function by Allen Browne: Concatenate values from related records

You could create a TextBox and set it's ControlSource to something like this:

=ConcatRelated("[ID]", "[Position Applied]", "[Personal ID] = " & [Personal ID]) 

This would give you a list of IDs separated by commas. There are also additional options that give you some flexibility. If what you want is beyond what the function can do, you could use is as a base point to create your own.

[NeoPa]

NeoPa:
Are you saying you'd like to see the linked records in continuous form mode in the Detail section of the main form?

I'm really looking for a yes/no answer here. Going back to the beginning and trying to explain again seems to be the standard response in most cases (so you're certainly not unique in missing the obvious here) but it doesn't help unless you can do it in a way that's clear. Alternatively, a simple yes/no should be all that's required. I take responsibility for extracting clarity from the situation.

Obviously, extra clarification never hurts. Adding it to a yes/no response is perfectly fine. Instead of? Not so much.