仅使用ID'S从表单填写表格 [英] Filling table from form using only ID'S
问题描述
这就是我的问题。
我有各种表格即
NL客户端（ClientID，ClientFirst，ClientLast，Address，邮政编码等。）
NL治疗（TreatmentID，治疗）
NL费用（CostID，费用）
NL客户治疗（ClientTreatmentID，ClientID， TreatmentID，CostID，日期）
正确我已经设置了三个工作表格。
第一个是进入新客户，这是有效的罚款。
第二个是输入新的治疗方法，这个工作正常
第三个用于输入新的费用，这个工作正常。
第四种形式是完全抛弃我的那种形式。我想要的是如下：
-Client Name（连接的名字和姓氏。我已经通过查询设置了这个连接。
-Treatment（A下拉菜单中包含所有可能的治疗方案供选择）
-Cost（可供选择的所有可能费用清单）
- 日期（日历从中选择日期）
现在我已经尝试了很多次来设置它，但我只是无法弄清楚如何，一旦上面的选择只保存相关的ID''到NL ClientTreatments表。希望这是有道理的。
我会尝试并附上数据库的副本。
Right here is my problem.
I have various tables ie.
NL Clients(ClientID,ClientFirst,ClientLast, Address,Postcode etc.)
NL Treatments(TreatmentID,Treatment)
NL Costs(CostID,Cost)
NL Client Treatments(ClientTreatmentID,ClientID,TreatmentID, CostID,Date)
Right I already have three working forms set up.
The first is to enter new clients and this works fine.
The second is to enter new Treatments and this works fine
The third is for entering new costs and this works fine.
The forth form is the one completely throwing me. What I want on this is as follows :
-Client Name ( Concatenated First and Last Name. I have already set this concatenation up via a query.
-Treatment ( A drop down menu with all possible treatments to select from)
-Cost ( A list of all possible costs to select from)
- Date ( A calender to select the date from)
Now I have tried so many times to set this up, but I just cannot figure out how to, once the above selections are made to save only the related ID''S to the NL ClientTreatments table. Hope this makes sense.
I will try and attached a copy of the database.
推荐答案
对，我找到了新的主题，并会更多地了解它当我回到家的时候彻底彻底。
Right, I''ve found the new thread and will look through it more thoroughly when I get home.
对，我找到了新的帖子，当我回到家时会更彻底地看一下。
Right, I''ve found the new thread and will look through it more thoroughly when I get home.
对不起，我已经下载了数据库，但还没有时间查看它。
明天会再试一次。
Sorry, I''ve got the database downloaded but had no time to look at it yet.
Will try again tomorrow.
该死的，你不睡觉吗？只看你上一篇文章的时间。
听着，不用担心。我想我们让这个到星期一。祝周末愉快。
Damn, dont you ever sleep? Just looking at the time of your last post.
Listen, no worries. I think we let this one go till Monday. Have a good weekend.
这篇关于仅使用ID'S从表单填写表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
