If you haven't spent time learning about relational databases and
normalization, I can understand how you might think you need to store the
same facts more than once (spreadsheets come to mind!).
It is not only possible, but desirable, in relational databases, to use
queries to re-associate the "information to show up on the form", without
having data duplicated.
There may be/are rare instances when data would be stored twice, but nothing
you've described yet argues for it.
If you have a main table and a "supporting" table (e.g., Orders, with
Customers), you wouldn't need to re-store customer name, address, ... in the
Order table. Instead, create a query that includes Orders and Customers,
joined on CustomerID (you'd use the CustomerID in the Order table to show
who placed the order). Select the fields you need to show.
Now base your form on the query.