获取 FileMaker Pro 数据库中新记录的最后插入 ID
我在一个看起来像
波士顿的字段中有一些数据,11/7/10,11/12/10,11/13/10 atlanta,11/11/10,11/15/10,11/18/10
我想要做的是使这个关系变得相关而不是单独存在于一个字段中,
所以到目前为止我所拥有的是我可以让它发出警报我每个项目都跟踪迭代等 然后我到达波士顿并说好吧我将把“波士顿”插入到我的城市表中,该表只有一个名称和 ID 然后我到达第一个日期,我说好吧我会将其插入到日期表中有一个 date 、 id 和 city_id 字段,那么问题来了,我如何知道该日期的城市 id 类型?
I have some data in a field that looks like this
boston,11/7/10,11/12/10,11/13/10
atlanta,11/11/10,11/15/10,11/18/10
and what I want o do is make this relational instead of being in a field by itself
so what I have so far is I can get it to alert me each item keeping track of iterations and such
Then I get to Boston and say ok I'm going to insert "boston" into my citys table which just has a name and id then I get to the first date and I say ok I'll insert this into the dates table which will have a date , id and city_id fields and there comes the problem how do I know what kind the city id would be for that date ?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这涵盖了在这篇文章中
this is covered in this post