New tables in a split database

[Guest]

I have split my database which simply consists of one table and one form (it
started off as a small project). I now want to add further tables to the
database and be able to enter data into these in a form the same as for the
original database. (The fields on each table are identical at this stage.)

I would appreciate any guidance on this one since this is all new to me! Do
I need to set up an entirely new database? Is it possible to 'copy' a form
to use with another table with the same fields? (The original form took a
while to develop, and I don't want to redesign the same thing three or four
time just because the data will be different!)

Thanks in advance!

 

[Albert D.Kallal]

You simply add a table to the back end, and then go to the front end, and go
new->link table.

I explain and talk about at "what" point in your project you might want to
split (or not split) in the following article:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

In the above I also explain the "step" of having to using the new->link
table.

In a nutshell, you often don't want to split until you are "well" into the
development phase, or at least "close" to the point where adding tables has
become "rare". For sure, you split before any of your users get the
application...

Anyway, give the above a read.....

 

[MacDermott]

Yes, you can copy your form -
just highlight it in the database window, then select copy - paste from
the Edit menu. (Or use ctl-C,ctl-V.)
You can right-click on it and rename it, too.

Then open it in design view, and display the Properties Window for the
form itself. You can change the RecordSource property to point at a new
table.

 

[Guest]

Thanks Abert. I have read through your article as I had previously found
reference to it within these discussions.

Unfortunately it wasn't possible to forecast the need for these additional
tables when the original database was set up a few months ago.

 

[Guest]

Thank you for your help - all worked! It all seems so simple when you know
how!
Thanks!

 

[Guest]

Thank you heaps for this! As I mentioned above, it all seems so easy and
logical when you know how!

This discussion site has been my life saver over the past few months!

Thanks again!