Creating new records

[thecopybook]

I'm new to Open Office and to databases in general, so forgive me if I'm making a very obvious mistake. I've created a new form in the design view. I've added text boxes and check boxes. I haven't cross-referenced this form with any tables.

I'd like to use this form to fill in various data about various books, one book per record, with the boxes the same for each. I thought I could do this in a database program, but have run into a wall. The form I've created looks great, however, it is limited to one record. Simply put, I can't create a new record. I can input one record into the form, but that's all. All the buttons on the form navigation toolbar are greyed out, and placing the mouse over the empty record box brings up the phrase "absolute record". What exactly am I doing wrong?

Best,

Colin

[kabing]

I think it's because you didn't connect the form to a table. How/where are you wanting to store the data you are entering?

kabing

[thecopybook]

I was hoping that the information could be saved within the form itself - evidently this is a foolish thought! Am I therefore right in saying that if I link each of the text boxes and checkboxes to fields within a table, I'll be able to create new records?

Colin

[kabing]

In Base, the data has to be stored in tables. You can enter new records and/or edit data via a form, but the form must be associated with one or more tables.

First, you need to associate the form with a table, and then associate each of the form controls to a field in the table. If you need more details, just post back.

Actually, even before that, you need to think through carefully how many tables you need and how they should relate to each other. Let me know if you'd like some assistance with that.

kabing