Linking Forms Together?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently creating a database for Financial Aid & Awards information,
its a pretty large database so far. I am enjoying creating it from scratch,
however have come across a few snags.

First: I want to link my Form pages together. I created them in Form so
there is no table to create a relationship. Can I link just the Form pages to
each other or do I have create the tables first?

Second: I want to include an option that you may click on to and more
information becomes available to the user. How do I do this?

If you could be of assistance that would be great!

Thanks,
Rose
 
I am currently creating a database for Financial Aid & Awards information,
its a pretty large database so far. I am enjoying creating it from scratch,
however have come across a few snags.

First: I want to link my Form pages together. I created them in Form so
there is no table to create a relationship. Can I link just the Form pages to
each other or do I have create the tables first?
Click to expand...

WHOA. You're WAY down the wrong track.

If you were building a house, you would not put up all the windows and
windowframes first, and then start thinking about where to pour the
foundation!

Data is stored in tables, and ONLY in tables. Forms *are just tools* to manage
the data in tables. You need to build your tables *first* - properly
normalized, with relationships defined; and THEN start work on your forms.
Second: I want to include an option that you may click on to and more
information becomes available to the user. How do I do this?
Click to expand...

By using VBA code in the Click event of a button control on a form (which
needs to be based on a table of course). Without knowing where this "more
information" might be coming from - other than from a Table of course - it's
hard to be more specific.

John W. Vinson [MVP]
 
Back
Top