Recent content by 20sunflower

Thanks. I've attached it as a JPEG now I think

How do I do that? Sorry for the dumb question but I don't know. I have the image saved in a word doccument.

I have 3 tables: guests rooms reservations with the primary key in the guest table as guest ID with the primary key in the rooms table as room number do I need a primary key in the reservations table?

I thought I could upload a screen shot of the relationships, but the file is too big.

Could someone please check the relationships between these entities? I think I've forgot to include a primary key in the reservations table. I think the primary key should be guest ID. Also, do I need a composite key? Thanks

I am quite confused by the database relationships I need to set up. Can someone help me please? I have a table that holds the basic information for each player-membership ID, First name, last name, Date of Birth, Address, Contact number Then I have a table with the scores that each player...

Hi How do I automatically copy data from one table to another? I have a table with player information and want to put the membership number into the fixture table automatically to avoid entering all the player ID numbers again.

I am only doing a database for a singles league to avoid that problem. My database doesn't have to be complex, just as long as it has 2 relationships, 2 forms, 2 reports, a macro, a query and a switch board.

Hi Would fixtures for a sports league be a feasable database? I could have table players, table league fixtures, table game scores and then make a report of results/performance including outstanding matches. Does this sound workable or is it better done in Excel? Thanks

Can you explain this to me because I don't follow what you are saying. I'm a beginner at databases. Would I use Player ID instead to track each player's fixtures?

Thanks for your reply. Do I create a table with week 1's date and the scores and then a table with week 2's date and then the scores and make the week ID the primary key?

Hi I'm trying to design a database for a sports league, but am having difficulty working out how i would keep weekly data and archive it in some way in order to input the following week's data. Any help appreciated.