Hi, i'm trying to create a program so i can log every person I meet, which i have done quite easily with databases. However i would also like to be able to log each time i meet that same person which is where i can't figure out what to do. T would seem to me like i would need two databases, one for the personal information, name, country etc and another for each time I meet them. I Have been unable to do this and ask if anybody can offer me suggestions?
Jump to Post
You don't need two databases, you need one database with two tables. One would be a Person table (or whatever you want to call it) where you store the relevant personal details (name, country, etc.) and the other would be a PersonEncounter (or whatever you want to call it) where …
Jump to Post
OK, let's assume you have a Person table with the following fields
PersonID (auto-incremented integer, primary key)
And you have a PersonEncounter table with the following fields
PersonEncounterID (auto-incremented integer, primary key)
PersonID (foreign key, references Person.PersonID)
And, for the purposes …
All 6 RepliesReply to this topic
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.