click next, and move up the Columns on the right side, ID_T will move down, to have no related column on the left side.select this query Q_TITLES in Queries - area rightclick, copy, go to Tables area, rightclick paste, type in T_TITLES and check Append Data.The size of my current spreadsheet is too large for the forum to allow me to attach it.Ĭode: Select all SELECT "T_SERIES"."ID_S", "Sheet1"."Title", "Sheet1"."Season", "Sheet1"."Episode", "Sheet1"."Year", "Sheet1"."Time", "Sheet1"."Rating" FROM "Sheet1", "T_SERIES" WHERE "Sheet1"."Series" = "T_SERIES"."SERIES" I know in Calc it's easy to add/remove/edit columns for things like these, but I don't know how easily (or possible) it is to do with Base.Īny suggestions and/or help would be appreciated. I'm not sure exactly what additional information I'm going to be adding (time, rating, full/wide screen and summary are a few that I've thought of). Part of the problem, I suspect, is that not all of the rows have data in all of the columns.Īdditionally, I've been thinking about expanding the spreadsheet to contain more information than the title and year (Title, year & episode # for TV series).
I did read up in the External Data sources section, and tried the various options given. Now I'm wondering how I can use this spreadsheet as the data source for a database. Since then I have converted the spreadsheet to various other formats, the latest being.
#MOVIE COLLECTOR SPREADSHEET PRO#
I started a spreadsheet years ago to track these in order to (try to) ensure I didn't get any exact duplicates.Īt the time I only had a spreadsheet program available to work with (student version of Quattro Pro for DOS). I have a fairly large collection of movies and TV shows that I've bought, been given, or recorded from TV.
0 kommentar(er)
