Form was created first before the Table

[riklacorte]

Hi everyone,

I'm new here. Just asking for an advice. Is it possible to create a Form first before the Table?
I'm done creating my template Form then trying to connect it with the Table I've also created however there's no option on the drop-down list for Control Source.



Any advice will be very much appreciated.

Thank you in advance

[Micron]

There won't be if the form is not bound to a table or query.
To answer the first question, yes you can. However, you can push one end of a wet rope up a hill too, but most people would not attempt it.
Since database normalization is of the utmost importance, the sensible thing is to create as many of the necessary tables and queries up front as is possible. Getting the foundation right will save you a ton of headaches later, so if you don't know what I mean by normalization, do yourself a big favour and research it before getting deeper.

[riklacorte]

Thank you so much for this. I really appreciate your response. It helps a lot really.

[Homegrownandy]

How would that form show if the customer has two orders?