Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Is there a simple way to automate moving of a record between tables in a database?

Hi. I'm a green user trying to develop my first database in LibreOffice Base 5.0 under Windows 10 (English). I have two tables - Applicants and Members. When an applicant is accepted I would like to be able to click a button and move their entire record from the Applicants table to the Members table. Is this possible? How do i do it?

Why don't I have them all in the one table with a membership flag? Because once they are a member I will add a large amount of extra data, and I don't want to take up all that space for people who may never become members. Also it makes it easier to interrogate the member table if I don't keep having to add the membership criterion. There will be thousands of members.

I appreciate any help.

Peter

Is there a simple way to automate moving of a record between tables in a database?

Hi. I'm a green user trying to develop my first database in LibreOffice Base 5.0 under Windows 10 (English). I have two tables - Applicants and Members. When an applicant is accepted I would like to be able to click a button and move their entire record from the Applicants table to the Members table. Is this possible? How do i do it?

Why don't I have them all in the one table with a membership flag? Because once they are a member I will add a large amount of extra data, and I don't want to take up all that space for people who may never become members. Also it makes it easier to interrogate the member table if I don't keep having to add the membership criterion. There will be thousands of members.

I appreciate any help.

Peter