Junction not working.

[stewartrose]

Hi Rich,

could you look at this for me please and tell me where I am going wrong it is driving me mad. I cannot get the right values to show in County.

Best regards from Alan

 

[namliam]

1) Why use a macro to run a function which exports some data? when you can do the export right then and there in the butten by just pasting the export code in the sub where you call your macro? Some ppl just like doing things the hard way i guess!!?!?!?!

2) I am unsure as to your problem you will have to be more elabare in you question (an example maybe for us NON US -- read euro"trash" -- ppl)

Regards

 

[stewartrose]

Multiple Tables

Hi Sorry,

Have a read of this, and you will understand better, thank you
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52897

Best regards from Alan

 

[Pat Hartman]

I don't know where to look for your problem. Are you asking about the prompt you get when you run the query? Are you asking about the reason that the combos show only numbers and duplicates at that?

Your tables are not properly structured.

tblState:
StateID (autonumber pk)
StateCode
StateName

tblCounty:
CountyID (autonumber pk)
StateID (fk to tblState)
CountyName

PS, don't define lookups in your table definitions. They are just confusing. Use queries and join the tables yourself as necessary.

 

[stewartrose]

Multiple Tables

Hi Thank you for your reply,


I have to say I am a total newbie to all of this, I am trying my best to learn, but it is hard at my age, so please forgive me.

I have changed the structure as you said, and i found a form, that i have modified to use my tables County and State, and that bit works, but how to interface it to search table is beyond me, the new version is attached to this message, if you could help with some points it would be greatly appreciated.

Best regards from Alan

 

[Pat Hartman]

It works fine as long as you choose a state for which there are counties.

 

[stewartrose]

Tables,

Hi Pat,

I have to add all the other data in for the othe Countys, but my problem is to get the form to store the correct infoformation in search database, and also use all the other inputs from search into the form.

Best regards from Alan