Need help restructuring table and building a form

[lawdy]

I have eliminated all fields on my tblCalender that were also on another table. This reduced it from 15 fields to 3. Yes 3. The other 12 fields are on tblProposal. The data for those 12 fields originates from actions on the proposal form. The 3 remaining fields on blCalendar.are: (I have renamed it to tblCal_2025)
1 fDate - a date field which contains the date for the work to be performed
2 fLngLineNo - a long data type which already exists in the table, 101 to 120
3 fLngProposalNo - a long data type that is unique to the one proposal
I have no idea how to start the new calendar form. I need to display the job name on the calendar form. The fDate, fLngLineNo, and fLngProposalNo do not get displayed. It also requires additional fields from tblProposal such as fStrNotes which I currently have another field beside the name field which turns the backcolor black if the proposal has a note.
My question is: How do I get the job name and other items on the calendar form. Oh, I cannot use the job name in place of the proposal number. There could be many proposals for a property. I hope I am not asking too much.
tblCal_2025
fDate fLngLineNo fLngProposalNo
9/23/2025salNo 101 123002
9/23/2025 102 20240805
9/23/2025 103 20250928
9/23/2025 104 20250891
9/23/2025 105 20250714
9/23/2025 106
9/23/2025 107


9/23/2025 108
9/23/2025 109
9/23/2025 110
9/24/2025 101 123002
9/24/2025 102 20240806
9/24/2025 103 123002
9/24/2025 104
9/24/2025 105
9/24/2025 106
9/24/2025 107
9/24/2025 108
9/24/2025 109
9/24/2025 110

[ArviLaanemets]

Depends on relation between proposals and jobs.

In case every proposal may have a single job only (and either a job may belong to single proposal or to many of them), you can use a query with join between proposal and jobs tables (which returns info from both tables), and use it as source of proposals form;
In case at least some proposal may have a several different jobs, you will need a jobs subform in your proposals form.

[xps35]

I (still) do not understand what the use and meaning of the tblCalender is. Please explain. Having a year in a table name is usually a bed idea. It means you have to change forms, queries, reports, relationships every year.
As I asked before, please show your datamodel or post a copy of your database.

[jojowhite]

maybe the frmAppCalendar on this demo can be of use to you.

[lawdy]

The tblCalendar is just a table currently containing 15 fields. The table is the source of the form frmCalendar which I have attached a partial image of it. This is what I think I am trying to get to. But tblCalendar currently has 12 fields what are also in another table (tblProposal ). The 12 fields are selected or created in tblProposal from a form frmProposal. The frmCalendar is used to schedule jobs.

I am studying the sample Calendar. I am not sure on it.

The problem is, without all the 15 fields, how do I get the data on frmCalendar?
See the attachment.
Well, there is no attachment because I do not have the little paper clip symbol.

[lawdy]

Found it. The image is attached

[lawdy]

I failed to answer one question above. The name tblCal_2025 is just a name. I have move the one, trying different things. The actual calendar is perpetual.

[lawdy]

I think I have found the answer. Make the record source a query!

[mike60smart]

Hi
This is jojo's db modified

[lawdy]

I really like the looks of that form mike60smart. I trying to study the code. I can't see what puts the data on the form. Can you help me there?

[jojowhite]

to enter the data, you double-click on the White (yellow if it has schedule) textbox then an entry form will appear.
to just view, click on the textbox and you can scroll up or down (if there are many entries).

[lawdy]

Thanks for your response jojowhite. I am talking about when the form opens. I see no record source on anything.

[jojowhite]

on the Load event of the Form, it is calling show_number sub.
after the code in show_sub is finish, it calls show_appointment sub.

the Sub show_appointment() is the sub that is called to show the "appointments" for each day of a given month/year.
it uses filtered recordset, and loop to each record.

[jojowhite]

if you already have a calendar form, maybe you can upload the db and we will see
how to modify it for your current Calendar table.

[lawdy]

I don't want to use my junk form. I love the form you sent. What type of field or container houses the appointment names? They are names do1 thru do42.