Make all fields in a table equal to one field in another table

[AndyDevine1]

hi there

Someone has set up a query and has asked people to edit the heading in COlumn A and change a bit of text eg to "week 9: October 19 to 25 October" before running the query

Do you know how I can link the query so it reads from a eg 'set up week' table and for the query to then autopopulates the table (with 'week 9: October 19 to 25 October')?

Also bonus question, as I am sure its much more difficult...if you could tell me how to set up a table/query so it creates the string one week at a time, would be great...week 9..week 10 etc..

First question is more urgent though

Many thanks for reading

Andy

 

[Joe4]

I don't think your request is quite clear.
Perhaps it would be clearer if you could post a small data sample that shows what you are trying to do?

 

[AndyDevine1]

Hi Joe4, apologies if I've been unclear

Someone has set up a make table query.

They have set up three fields (week, month and year)

In the week field, for example, they have set up heading which reads eg WEEK: "2014 Week 3: 14 - 20 September"

When the query is run the table is created with the fields populated.

However people have to change the headings manually.

I thought it might be better to have a 'Set up dates' type table. And the query uses the dates from this table when it creates the new table?

Do you think this is a good idea? and can show me how to do?

Thanks

Andy

 

[Joe4]

I am still not sure I understand (an actual example with data would go a long way).
You could also post the SQL code for the current Update Query (that may help clarify things too, when we can see what is going on).

Are you saying that you want the Field Name (header) to be dynamic, or individual Field Values to be dynamic.

Generally speaking, you typically want your field names to be static.

 

[AndyDevine1]

Hi Joel4

I appreciate your help on this

Apologies again, I am trying to be as clear as I can...

If I go into the design view of Query1 and then to the field called Week and then to build I see (currently): WEEK: "2014 Week 3: 14 - 20 September"

When I ran the query it builds a new table (with data from table 1) and populates each cell in column A of the new table with WEEK: "2014 Week 3: 14 - 20 September"

This is all good and works perfectly however I thought that rather than have someone go into a query and change the field heading this could be done in a different/better way? eg by having them enter a date once in a (eg) "set up date" table and then for the new table to get the date from there?

Out of interest, if people want to include dates or week commening in a column in a table how does this normally work?

The bigger picture here is that we ran a set of queries each week with the latest data being tagged with the week and month and year before being appended to a master table. Pivot tables in Excel which are linked to a master table in Access can then report on the results by week.

Hope you can help and ive been clearer? Really appreciate you reading..

Cheers

Andy

 

[Joe4]

OK, so you are talking about updating a field value, not a field name.

This can certainly be done. There is more than one way to do this. Here are a few ideas I have used in the past:

1. Is there a pattern or logic that can be applied here (i.e. every Monday, we want to build a table using the dates from last week)? Is there is a predictable pattern, we can probably write a formula to come up with the value you want without any input.

2. Use a single record table to hold values that you want to use in your query. Then use both this table and your data table together in your update query.

If you need help incorporating these, please provide us with:
- the logic of the formula
- the value you are storing in your table (if using option 2)
- the SQL code of your Update Query (just change the query to SQL View and Copy and Paste the code here)

 

[AndyDevine1]

Hi Joe4 thanks again!!

Re option 1:
The reports are run every Monday and contain data for the previous week (Sun - Sat). For example the report ran on Monday of this week (27th Oct) was for data from Sun 19th Oct - 25th Oct

We need the master tables to include 3 fields:

Week: "Week [eg 9]: Sun 19th Oct - 25th Oct"
Month: "[eg October]"
Year: [eg 2014]

Equally, for the Week I'm sure we could 'get away' with doing week commencing
Eg Week: "Week [eg 9]: Sun 19th Oct" instead of above

However, to complicate things (??) reports need to cover a shorter period than a week if the week crosses into another month

For example, on Monday 3rd Nov, we'll produce one report for Sun 26th Oct to Fri 31st Oct and one report for Sat 1st Nov

Re Option 2:
The values are as option 1 above (week, month , year)

(Modified so I dont get in trouble) SQL is:

SELECT [RAW DATA TABLE].Primary_key, "2014 Week 3: 14 - 20 September - TEST" AS WEEK, "OCT-14" AS [Client 1TH], "" AS MediY_Spend, IIf([RAW DATA TABLE]![Placement] Like "*_X_*","Client 1",IIf([RAW DATA TABLE]![Placement] Like "*Y_*","Client 2",IIf([RAW DATA TABLE]![Placement] Like "*Client 2*","Client 2",IIf([RAW DATA TABLE]![Placement] Like "*Client 1*","Client 1","")))) AS BRAND, LOOKUP_TABLE_001_SITE_LOOKUP.Channel AS CHANNEL, LOOKUP_TABLE_PLACEMENTS_LOOKUP.REPORTED_SPLIT AS PLACEMENT_SPLIT, IIf([RAW DATA TABLE]![Placement] Like "*UK_*","UK",IIf([RAW DATA TABLE]![Placement] Like "* UK *","UK",IIf([RAW DATA TABLE]![Placement] Like "*_SUPPLIERD*","SUPPLIERD",IIf([RAW DATA TABLE]![Placement] Like "*FR_*","FR",IIf([RAW DATA TABLE]![Placement] Like "*SUPPLIERU_*","SUPPLIERU",IIf([RAW DATA TABLE]![Placement] Like "SUPPLIERD_*","SUPPLIERD","")))))) AS COUNTRY, IIf([RAW DATA TABLE]![Placement] Like "*STRUQ*","RETARGETING",IIf([RAW DATA TABLE]![Placement] Like "*RETARGETING*","RETARGETING",IIf([RAW DATA TABLE]![Placement] Like "*RET*","RETARGETING","PROSPECTING"))) AS PARTNER_TYPE, (IIf([RAW DATA TABLE]![Site]="TURN.COM","Betaphi",[RAW DATA TABLE]![Site])) AS PARTNER, "" AS TOTAL_DISCOUNT, IIf([RAW DATA TABLE]![Impressions SUPPLIERDlivered]<>0,([RAW DATA TABLE]![Impressions SUPPLIERDlivered]/1000)*0.00,[RAW DATA TABLE]![Clicks]*0.000) AS TOTAL_ADSERVING, "" AS TOTAL_REVENUE, "" AS TOTAL_POST_CLICK_REVENUE, "" AS TOTAL_POST_VIEW_REVENUE, [RAW DATA TABLE].Creative, IIf([RAW DATA TABLE]![Creative] Like "*UNIQUE*","UNIQUE",IIf([RAW DATA TABLE]![Creative] Like "*ROTATE*","ROTATE",IIf([RAW DATA TABLE]![Creative] Like "*ROOT*","ROOT","SITE TARGETED"))) AS [CREATIVE SET], IIf([RAW DATA TABLE]![Creative] Like "*120x600*","120x600",IIf([RAW DATA TABLE]![Creative] Like "*160x600*","160x600",IIf([RAW DATA TABLE]![Creative] Like "*300x250*","300x250",IIf([RAW DATA TABLE]![Creative] Like "*728x90*","728x90",IIf([RAW DATA TABLE]![Creative] Like "*300x600*","300x600",""))))) AS CREATIVE_SIZE, "" AS TOTAL_CONVERSIONS, "" AS TOTAL_NEW_CONVERSIONS, "" AS TOTAL_EXISTING_CONVERSIONS, "" AS NEW_SALE_PV, "" AS EXISTING_SALE_PV, "" AS NEW_SALE_PC, "" AS EXISTING_SALE_PC, [RAW DATA TABLE]![Impressions SUPPLIERDlivered] AS TOTAL_IMPRESSIONS, [RAW DATA TABLE]![Clicks] AS TOTAL_CLICKS, [RAW DATA TABLE].Placement, "" AS Creative_Cleaned, LOOKUP_TABLE_001_SITE_LOOKUP.[DISCOUNT_%], [RAW DATA TABLE].SITE AS RD_SITE, LOOKUP_TABLE_PLACEMENTS_LOOKUP.Placement AS RD_PLACEMENT, [RAW DATA TABLE].Creative AS RD_CREATIVE, [RAW DATA TABLE].TimeLag AS RD_TIMELAG, [RAW DATA TABLE].[Impressions SUPPLIERDlivered] AS RD_IMPRESSIONS_SUPPLIERDLIVERED, [RAW DATA TABLE].Clicks AS RD_CLICKS, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERD ClickThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_SUPPLIERD_CLICKTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERD ViewThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_SUPPLIERD_VIEWTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Fr ClickThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_FR_CLICKTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Fr ViewThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_FR_VIEWTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Uk ClickThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_UK_CLICKTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Uk ViewThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_UK_VIEWTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERU ClickThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_SUPPLIERU_CLICKTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERU ViewThru Value] AS RD_EXISTING_CSUPPLIERUTOMER_SUPPLIERU_VIEWTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERD ClickThru Value] AS RD_NEW_CSUPPLIERUTOMER_SUPPLIERD_CLICKTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERD ViewThru Value] AS RD_NEW_CSUPPLIERUTOMER_SUPPLIERD_VIEWTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_Fr ClickThru Value] AS RD_NEW_CSUPPLIERUTOMER_FR_CLICKTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_Fr ViewThru Value] AS RD_NEW_CSUPPLIERUTOMER_FR_VIEWTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_Uk ClickThru Value] AS RD_NEW_CSUPPLIERUTOMER_UK_CLICKTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_Uk ViewThru Value] AS RD_NEW_CSUPPLIERUTOMER_UK_VIEWTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERU ClickThru Value] AS RD_NEW_CSUPPLIERUTOMER_SUPPLIERU_CLICKTHRU_VALUE, [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERU ViewThru Value] AS RD_NEW_CSUPPLIERUTOMER_SUPPLIERU_VIEWTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 2_SUPPLIERD ClickThru Value] AS RD_SALE_VALUE_Client 2_SUPPLIERD_CLICKTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 2_SUPPLIERD ViewThru Value] AS RD_SALE_VALUE_Client 2_SUPPLIERD_VIEWTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 2_Fr ClickThru Value] AS RD_SALE_VALUE_Client 2_FR_CLICKTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 2_Fr ViewThru Value] AS RD_SALE_VALUE_Client 2_FR_VIEWTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 2_Uk ClickThru Value] AS RD_SALE_VALUE_Client 2_UK_CLICKTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 2_Uk ViewThru Value] AS RD_SALE_VALUE_Client 2_UK_VIEWTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERD ClickThru Value] AS RD_SALE_VALUE_Client 1_SUPPLIERD_CLICKTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERD ViewThru Value] AS RD_SALE_VALUE_Client 1_SUPPLIERD_VIEWTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_Fr ClickThru Value] AS RD_SALE_VALUE_Client 1_FR_CLICKTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_Fr ViewThru Value] AS RD_SALE_VALUE_Client 1_FR_VIEWTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_Uk ClickThru Value] AS RD_SALE_VALUE_Client 1_UK_CLICKTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_Uk ViewThru Value] AS RD_SALE_VALUE_Client 1_UK_VIEWTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERU ClickThru Value] AS RD_SALE_VALUE_Client 1_SUPPLIERU_CLICKTHRU_VALUE, [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERU ViewThru Value] AS RD_SALE_VALUE_Client 1_SUPPLIERU_VIEWTHRU_VALUE, [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERD ClickThru Value], [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERD ViewThru Value], [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Fr ClickThru Value], [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Fr ViewThru Value], [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Uk ClickThru Value], [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_Uk ViewThru Value], [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERU ClickThru Value], [RAW DATA TABLE].[Existing_CSUPPLIERUtomer_SUPPLIERU ViewThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERD ClickThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERD ViewThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_Fr ClickThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_Fr ViewThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_Uk ClickThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_Uk ViewThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERU ClickThru Value], [RAW DATA TABLE].[New_CSUPPLIERUtomer_SUPPLIERU ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 2 ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 2 ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 2_SUPPLIERD ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 2_SUPPLIERD ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 2_Fr ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 2_Fr ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 2_Uk ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 2_Uk ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERD ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERD ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_Fr ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_Fr ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_Uk ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_Uk ViewThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERU ClickThru Value], [RAW DATA TABLE].[Sale_Value_Client 1_SUPPLIERU ViewThru Value], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_SUPPLIERD Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_SUPPLIERD View], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_Fr Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_Fr View], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_Uk Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_Uk View], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_SUPPLIERU Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 2_SUPPLIERU View], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_SUPPLIERD Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_SUPPLIERD View], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_Fr Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_Fr View], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_Uk Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_Uk View], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_SUPPLIERU Click], [RAW DATA TABLE].[Ex_CSUPPLIERUt_Client 1_SUPPLIERU View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_SUPPLIERD Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_SUPPLIERD View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_Fr Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_Fr View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_Uk Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_Uk View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_SUPPLIERU Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 2_SUPPLIERU View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_SUPPLIERD Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_SUPPLIERD View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_Fr Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_Fr View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_Uk Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_Uk View], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_SUPPLIERU Click], [RAW DATA TABLE].[N_CSUPPLIERUt_Client 1_SUPPLIERU View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_SUPPLIERD Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_SUPPLIERD View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_Fr Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_Fr View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_Uk Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_Uk View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_SUPPLIERU Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 2_SUPPLIERU View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_SUPPLIERD Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_SUPPLIERD View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_Fr Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_Fr View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_Uk Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_Uk View], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_SUPPLIERU Click], [RAW DATA TABLE].[SVal_Ex_CSUPPLIERUt_Client 1_SUPPLIERU View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_SUPPLIERD Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_SUPPLIERD View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_Fr Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_Fr View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_Uk Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_Uk View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_SUPPLIERU Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 2_SUPPLIERU View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_SUPPLIERD Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_SUPPLIERD View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_Fr Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_Fr View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_Uk Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_Uk View], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_SUPPLIERU Click], [RAW DATA TABLE].[SVal_N_CSUPPLIERUt_Client 1_SUPPLIERU View], [RAW DATA TABLE].Creative AS Orig_Creative, [RAW DATA TABLE].MediaPlex_Creative, [RAW DATA TABLE].TimeLag INTO [T001 Client 1-Client 2]
FROM LOOKUP_TABLE_PLACEMENTS_LOOKUP RIGHT JOIN ([RAW DATA TABLE] LEFT JOIN LOOKUP_TABLE_001_SITE_LOOKUP ON [RAW DATA TABLE].Site = LOOKUP_TABLE_001_SITE_LOOKUP.SITE) ON LOOKUP_TABLE_PLACEMENTS_LOOKUP.PLACEMENT = [RAW DATA TABLE].Placement;



Many thanks

Andy

 

[Joe4]

OK, I think the easiest thing is to create a one record table to hold your "inputs".
Then, simply add this table to your query. Since it is just one record, you do not even need to establish a "join" or "relationship" with your other tables.
Then, add the fields you want from this table to your query.

What I usually like to do is create a form for this "inputs" table. After sitting up an initial single record, I go to the Form Properties and change the "Allow Additions" and "Allow Deletions" properties to "No". That way, people can only ever edit this single record, and never delete it or add more records (important for your query to work properly since there is no join). Then control all data inputs from this form (never edit the table directly).