Question about entering data through form

[vixtran]

I ahve a question that may be easily answered.
I have a main project table that is connected to another table. lets say one table project the other table customers..
table 1 is joined to table 2 with a many to 1 relationship.. 1 customer can have many projects.. table 1 having PK and 2 FK
if I wanted my first form to be my project table.. how could I fill the info out and then creat a new record without physically entering in the customer FK in prior.. I tried the cascade update.. however I dont think I get it...
what am I missing?
thanks many times in advance!!

[RuralGuy]

I'm not sure what your question means but the Customer control on your form should be a ComboBox that stores the CustomerID in the Projects table.

[vixtran]

So I would prepopulate the customer table with the customer information? I was hoping to start with the project table then move to customer information; however, I wanted to display the customer on the project page. Ideally I would like to do this in tabbed form. I am reading and learning one day at a time!!


thanks!!

[RuralGuy]

You can't enter anything in an accounting system with out first defining your Chart of Accounts either. First things first.

[marianne]

that is true....RG is right

[vixtran]

That is true.. Sometimes little baby learning step sometimes big!

I dont quite have all the basic workings down. Well I atleast I am not aware of them all. I am trying to figure out my table relationships and it has not been the enlightening experience I had hoped for! ..

I am at a point where I am not sure if I am defining the relationships correctly, thus the question about the form. On top of that, my brain is locked in speadsheet layout form.. I have been doing a lot of reading..normalizeation.. so on.. you get to a certain point where experience plays a role.. unfortunately.. I am lacking in that area..

[RuralGuy]

It sometimes takes a while to free yourself from the spreadsheet mindset. Think Tall and Thin rather than Short and Wide.