sempuritoza
Programmer
i am very unexperienced with access so even for small things like this i need some help. i have a table(A) which has a one to many relationship with table (B) and i need to get all the fields from table B that correspond in table A.
i know i need to use the modeule builder but i dont know how to connect to the db and then run a query and then put that into a loop and continously concatinate the string to itself plus the new value(this is the basic procedure i am geussing cause this is how i would do it in PHP)
what is the syntax that i have to put together to
1. connect to the database
2.run a query that selects all the fields in table B which are relevant to table A
3. start a loop in which i can concatinate all the fields
4. reutrn the string
any help will be greatley appreciated, i feel like i am computer illetrate at the moment and this aint a nice feeling
thanx
i know i need to use the modeule builder but i dont know how to connect to the db and then run a query and then put that into a loop and continously concatinate the string to itself plus the new value(this is the basic procedure i am geussing cause this is how i would do it in PHP)
what is the syntax that i have to put together to
1. connect to the database
2.run a query that selects all the fields in table B which are relevant to table A
3. start a loop in which i can concatinate all the fields
4. reutrn the string
any help will be greatley appreciated, i feel like i am computer illetrate at the moment and this aint a nice feeling
thanx