How to create
How to create
I am new to cardbox and it seems ideal for what I want. I have created my first simple data base easily and successfully. I would now like to expand it and create a relational file.
For example I have a list of wildlife and I want to add an ever growing list of the dates and places I have found them. Is there a very simple guide to doing this or better still is there a sample file I can download and use as a guide and build on that.
A Cardbox file is not relational; it never is. That's one of the reasons why they are to simple to make and maintain. Cardbox has however a very powerful feature: relational searching. Relational searching does not depend on the structure of the files. It comes down to the following:
Database A and database B contain records and these records contain data. Both databases can be searched and edited independently.
A and B both contain the names of animals. Let's assume this field is called SPECIES.
Suppose you then browse through A. Record 1 contains "hare". This name is sent to B and a selection appears of all records with "hare". You browse to record 2 from A which contains "falcon". The selection in B immediately changes and displays all records of falcons. Etc.
You can also set this up the other way around, which means you can have A show all the specifics of wildlife that occur in B.
Thank you Charles
I can work on that.
I also am new to Cardbox and for an art show I am running I need to create a database that manages
My question is should I
A... put all data in the one "artist" file with fields for up to 5 ( the max allowed) paintings)
No apologies are called for. On the contrary: your question indicates that you thought things over.
The "trouble" is that the flexibility of Cardbox allows you to do both with equally good results. Let's take a look at this from both ends:
Your database is somewhere in-between. You could easily have a single database, especially as there is a limited number of works of art. You could even have single fields for name, medium, price etc. all containing your maximum of 5 entries, where the first name corresponds with the first price and the first medium etc.
Perhaps now you see why I used the word "trouble". Cardbox allows you to do things in many ways, which makes it sometimes hard to decide which is best.
In your case both options are more or less balanced. If however you want to make printed copies, I'd go for the single-file option. There's no easy way to print data from two databases as a single copy.
Whatever you decide, remember that it's easy to change things. If necessary you could easily update a single file to a relational setup.
The best advice I could give you is that you test both options before you really give it a go.
Charles did say
'....There's no easy way to print data from two databases as a single copy.'
That statement leads me to the single datab ase option because a major task is to prepare a PDF file for the catalogue.
Many thanks Charles for your assistance
I'm a convert..I've bought the Book but it says very little about the relational aspects of Cardbox. I would really like to get my hands on a sample database which can show me how best to proceed. I have been an avid user of Rapidfile for over 25 years and I just get the feeling that Cardbox builds on that simplicity but adds much more including relations/linking. My goal is to develop a "simple" database for parents and students for emailing purposes. Given that parents have multiple children and children have multiple parents my head starts to spin, so any guidance will be much appreciated. I am very new to this so please be patient. Many thanks
Again: Cardbox is not a relational database. And it is not RapidFile clown.
Best workaround for these limits is programming macros. You could make a database for parents and a database for children. Make for adding records a macro which can connect a key field in both, and run from time to time a macro which updates all records of the parents database by renewing the children field in that db). Then you get one flat database with parents & children which easy can be updated by a macro.
Hi Bert, Thanky for the quick reply. I was clear that Cardbox is not a relational database but equally clear that it can make relational links. I only mentioned Rapidfile to indicate that my skill is fairly basic and that over the years I have been able to do a lot of good work with it.
Obviously Cardbox can go a lot further and when I saw the example of the Galpin Society Membership database on page 225 of the Cardbox Book, which shows two files open and related, I felt that Cardbox could offer me a solution.
I have a better idea on how to proceed but you can't beat example files to play with.
Cardbox Sample files: the re installed in a subfolder of the program folder of Cardbox.
I know where the sample files are. My question relates to sample files using relational links. There are no sample files using relational links ... or am I going blind!
I repeat, the Galpin society is mentioned as an example of using links but NO FILES TO PLAY WITH
The menu section has an entry called Help points
In sample db Contact is a simple relational search possible:
So you are not blind, you only did not read the right stuff...
|© 2010 Cardbox Software Limited|