Browsing and linking multiple records

[Scottie]

G'day guys,

I've had a search around with not much success so I hope this is possible in some way!

I have a table for companies providing different services, a table for each as they have differing requirements. I also have tables for the staff they use to provide it and I'd like to create a central location/form to view tham based on the company selected (using a combo box, unless there is a better way?)

All the tables are related using the company name, so my main issue is listing the results filtering to the selected company in an After Update event.

But, I have higher hopes which may require some tricky considerations in the previous instance.

After I have filtered the services/staff as above, I have dreams of being able to select them and go to a form displaying the more specific details about them.

I think this might be more suited to something based on webpages, but that defeats the purpose of a database... unless there's some front-end feature I'm yet to discover?

anyway, I hope it isn't as complex as I think it is... I'm just relatively new to all this as it is, but if it is possible then I'd happily be the first to try it.

I could post up what I have currently, but it's kinda large so I'll need to take out a few things before I post it if anyone needs it.

Thanks in advance!!!

Scottie.

 

[Scottie]

Ok, so I've kept digging, trying to find different ways of doing this...

Referring the query to the form control was close, but it kept getting confused as the form opened as the combo box wasn't displaying a value.

Other methods included general filtering and search methods, but the area where this keeps getting stopped on is (I believe) the fact that it is trying to run off a Union Query. I can't seem to find a way to get a filter working in SQL allowing for additional information being added later on.

I'd make a unique query for each service or company, but with the new data being added and the amount of attention to include new queries for the new data will be very time consuming and (i think) not that efficient.

I'll get an example out tomorrow to maybe give someone who is willing to lend a hand a better idea of what I'm trying to achieve.

Cheers!

Scottie.

 

[Scottie]

Ok, when creating my example db I got it to work with placing the WHERE statement in the union query and referring the particular field to the form control value. So after fiddling around with my actual db, that ended up working also.

Now to try and create a link to the more detailed forms from the results!

I could either make a new field with a macro in it somehow? Has anyone got any tips on linking query fields to records in separate forms? Either way I'll keep snooping around, but unless there's a good theory I haven't stumbled across yet...

cheers!

Scottie