Main form Sub form issues

[Blabolat]

So I have your main form and the sub form (Service Order/Service Detail)
I had originally had a continuous detail subform but found it didn't work well so I switched to a singe form.

The trouble is, you don't get a peek at the other Details of the subform. Ideally I would want to use a split-form, but that doesn't work as a sub form.

So I created a continueous sub form for the Service Detail that you can quickly take a look at the skinny of it. What I'd like to do is click on the Service detail number from the skinny and have the form show up on the main sub form.

That what I'm lost in, if that can be done or not.

This is the screen shot of the main form, the sub form and right below the sub form the skinny

[/IMG]

 

[GinaWhipp]

How are the Tables that house the data related? In other words, what are the Primary Keys and Foreign Keys?

 

[Blabolat]

Main form SOID linked to Service Detail form by SOID.
Service order primary key is SOID
Service Detail primary key is SDID and linked using soid

The skinny form is exactly the same as the service detail form.

should the skinny form be somehow linked to the Service detail form somehow.. perhaps record number?

 

[Blabolat]

Soo I think I figured it out.

quite simple actually, I created a 2nd form and set it to be a popup model.
Fact is, I think this will work out even better, than going to the record on the main form.
Thanks!

 

[GinaWhipp]

Hmm, that was what I was going to suggest! I guess I was just here to give your brain a boost.

 

[Blabolat]

Hmm, that was what I was going to suggest! I guess I was just here to give your brain a boost.

haha! you were?

well, I thought I came upon something, but then yeah, I"m sure you would have suggested it. thanks!

Along the way I found another trick.

I have a filter that I use a text box and a button to find what I'm looking for.

Well I was getting errors if I didn't put any number than that was there..

So I created a drop down list and used the limit to list.
made the text box to equal the combo box and it solved all errors.. still get it but it doesn't go into debug mode anyway.

Thought that was pretty clever.

Cause what was difficult was that I want to use the racquet id number from the main opening screen and have it trickle down to the service order and selecting the user name and the racquet ID at the same time.

Now I don't have to lookup the user, then lookup the Racquet ID..
I just scan the ID from the opening screen, viola! done!



thanks for the help!

 

[GinaWhipp]

Glad to help... though you did all the work!