New database w/4 tables, trying to create entry form w/all info?

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

Guest

I have created a database w/4 tables, all relational to 1 table. Basically,
I have a firm info table, a contact info table, a disciplines table (which
has about 15 check boxes) and a comment table. Each table has been put into
a relationship with the firm info table, using a foreign key. I cannot
create a form that allows me to input information. I even tried to place
everything into one table to create the form, but it still won't allow me to
make entries. I can enter into each individual form for each table, but not
into one that contains all the information. I'm brainstorming as I type so,
is it possible that look up boxes in each table would keep me from being able
to create one form that allows entry? I've tried just about everything I can
think of. Can someone please help.
Thanks
 
On Feb 23, 2:36 pm, citygirl <[email protected]>
wrote:

"I have a firm info table, a contact info table, a disciplines table
(which
has about 15 check boxes) and a comment table. "

So each Firm can have many Contacts, Disciplines, and Comments?

Make each form separately then open the Firm form in design view and
drag and drop the subforms (Contacts, Disciplines, and Comments) into
it.

Save the Firm form then open it. Since they're all linked to the same
key (Firm_ID as their foreign key) they should link up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top