Can I make form based on fields from 2 tables?

R

richardm55

Registered User.

Local time

Today, 18:17

Joined

Feb 9, 2014

Messages

28

• Feb 15, 2014

• #1

I have created simple data base containing 2 tables connected each other and I wanted to make a form with fields taken from those tables and unfortunately it did not work and I got errors message.
Before I start to build the form do I need to create the query based on those tables and having the fields I need for the form? If yes, what sort of query, simplest one?

 

bob fitz

AWF VIP

Local time

Today, 18:17

Joined

May 23, 2011

Messages

4,801

• Feb 15, 2014

• #2

What is the relationship between your two tables. Most common is a one to many relationship, in which case you would normally have a main form with the data from the one side and a subform for the data from the many side

 

R

richardm55

Registered User.

Local time

Today, 18:17

Joined

Feb 9, 2014

Messages

28

• Feb 15, 2014

• #3

Yes, relationship is one to many. But I am not sure if it is better to put all fields to one table. I never know when to create separate table for some data. To make it clear I will explain all my date base. I want to create the data base of articles from various electronic magazine. I am going to use such fields:
1. Name of article
2. Name of magazine where article is located
3. Year of issue of magazine
4. Month of issue of magazine
5. Brief description of article
6. Type of article
7. Key components/units used in article
8. Application

I wanted to keep fields:2, 3 i 4 in separate table and call it location of article but I am not sure it is worth to do that.

 

bob fitz

AWF VIP

Local time

Today, 18:17

Joined

May 23, 2011

Messages

4,801

• Feb 15, 2014

• #4

Perhaps a little knowledge on Normalization of the db would help. There must be thousands of pages written on this. Try a search of this and other Access forums or try Google search. Here is one I found on Google: http://databases.about.com/od/specificproducts/a/normalization.htm

 

R

richardm55

Registered User.

Local time

Today, 18:17

Joined

Feb 9, 2014

Messages

28

• Feb 15, 2014

• #5

Could you give me link to other forums and tell me pls which forum is the best?

 

bob fitz

AWF VIP

Local time

Today, 18:17

Joined

May 23, 2011

Messages

4,801

• Feb 15, 2014

• #6

you may like: http://www.accessforums.net/
or: http://www.utteraccess.com/forum/index.php?app=portal

As for which is best, well, that's a very personal and subjective assessment. Not one I would care to pass comment on. But IMHO this one is very good.

 

R

richardm55

Registered User.

Local time

Today, 18:17

Joined

Feb 9, 2014

Messages

28

• Feb 15, 2014

• #7

I don't know how to add value into kombi formant if table is empty yet and this kombi formant takes date from the table. So probably I must firstly add some values dealing with kombi formant just manually direct into the table.