Creating form using wizard

[lywong111]

Hi all,

I need to create a form in access using wizard.However in the form, I have many textfields which to need to be bound to different table. How do I do it using wizard?

EG: txtbx1 data go into tbl1
txtbox2 data go into tbl2 etc...

Pls advice. Thanks

 

[TheAceMan1]

How are ya lywong111 . . . .

How many tables are we talkin here?

You may have to think about relationships 1st!

See Ya! . . . . . .

 

[lywong111]

Hi Aceman,

If I wana use wizard to insert data into different tbls in a form, I MUST have relationship (like foreign Keys) thgy?

Any websites to teach u how to use Access wizard?? Pls recommend..Thanks alot!

 

[pifko]

http://www.fgcu.edu/support/office2000/access

tis good

 

[TheAceMan1]

lywong111 . . . .

No . . . you don't have the relationship thingys. But then it would'nt be a Relational Database! Besides, 99.999%of the time, they are used and are necessary for extraction of data . . . . espcially with Multiple Tables. You could find yourself redesigning too many times and getting in a rut.

pifko example is OK, but its missing an all important grouping window and I don't believe it gives the detail your looking for. The wizard is pretty much straight forward once you go through it, but apparently you havn't used it much . . . .

Hang in there . . . . looking for something more worthy to suite your needs . . .

See Ya! . . . . . .