Add tables to forms

[harpscardiff]

Hi All,

Did a quick search but couldnt find anything....
Bascially I want to create a form from multiple tables....
How easy is this to do?

Thanks

 

[KenHigg]

Hum... Pretty basic stuff. You can join the tables in the forms underlying recordsource or place a subfrom on the main form. This forum is going to be a little frustrating if you are trying learn these basics, it's best for helping each other with snags and specific problems. Are you using a book to learn Access?

 

[harpscardiff]

I've got one on order!

 

[KenHigg]

Cool, In the mean time, did the suggestions I propose make sense?

 

[harpscardiff]

Thanks for advice....It worked.

Basically, i've created the tables in MySQL and linked the tables in access. now i need to make a tab controlled form based on the tables.....Tyring to replicate An iT helpdesk....http://demo.ilient.com/SREdit.jsp?id=0
Its a pretty basic Helpdesk, hopefully shouldn't be hard to replicate.

 

[KenHigg]

Sounds like an interesting project - good luck.

 

[harpscardiff]

But as i'm a novice at access, I will be on this site alot!!

Thanks.