Although Northwind is designed for sales orders, the structure you need will
be very simple, except you will have a table of Vendors instead of
Customers.
You can also see how the Orders form works in Northwind, for an idea of how
to build your interface.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Sammy" <anon...@discussions.microsoft.com> wrote in message
news:14df401c3f9a4$5056bb80$a601...@phx.gbl...
>.
>
The Orders table also has a CustomerID field.
Did you resize this to 20 characters as well?
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Sammy" <anon...@discussions.microsoft.com> wrote in message
news:140ee01c3f9c5$3ccbd250$a101...@phx.gbl...