1 Reply by asayami_design

(7 replies, posted in General)

When I try to create this myself, something isn't working.

I have three tables

owner table (ownername TEXT)
vehicle table (vehiclename TEXT )
vehicleowner table - with relationships to each of the above

by creating the forms

frmVehicle, frmOwner, frmPickVehicle, frmPickOwner etc exactly as in the example...

I can see that when you pick a vehicle, the vehicle ID is put in the join table, but not the ownerID it corresponds to... and vice versa.

What have I missed?

Go to forum: General

2 Reply by asayami_design

(7 replies, posted in General)

Thank you.

The example is very helpful.

Go to forum: General

3 Topic by asayami_design

(1 replies, posted in General)

If you change the program data structure after creating your application you are prompted to delete your database and start over. If you don't delete the database, then the structure changes don't seem to be picked up.

Clearly, if you have typed in a lot of records, then decide later on to add a new feature to the database application, that say requires adding a new table, then having to delete the data and start over is hardly convenient.

Is the recommended option to add new tables using a third party sqlite tool? or am i missing something important and this behaviour isn't what's supposed to be happening.

Go to forum: General

4 Topic by asayami_design

(7 replies, posted in General)

Hi, I was looking through the example databases for one that implements master detail style records. How can you do this without using scripts.

Scenario: I have a number of records that have several fields, and I want to arrange them into collections such that a given collection consists of some information unique to the collection and then it will contain one or more of the item records. Each item record should be viewable separately outside of the collection, but may be part of one of more collections.

In the phone example, adding a new detail record is possible, but there is no examples anywhere of linking to a pre-existing record, you only seem to be able to add new ones.

Traditionally, I guess what i need is a many to many relationship using a join table, but I dont see how to implement this without writing script code.

Go to forum: General